All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag like sql-server-2016 if that is relevant to the question.

learn more… | top users | synonyms (2)

0
votes
0answers
819 views

SQL Server Agent - Will Job Run on Specific Future Date?

I have a number of SQL Server Agent jobs will different types of schedules (Daily, Weekly, Monthly). Each of these jobs will represent an event. For example there will be an FTP job that will ...
2
votes
0answers
53 views

Running SSIS on SQL Server without SSIS installed [duplicate]

This is a follow-up to this question: Running an SSIS package without the SSIS service installed I have build an SSIS package on my local machine but when deploying to a server, I get the following ...
4
votes
1answer
2k views

Script all tables in a database

In SQL Server 2008 - is there any script available which will list all tables (incl column names, data type, length) for the entire database - with one script.
10
votes
1answer
521 views

Poor query performance

We have a large (10,000+ lines) procedure that typically runs in 0.5-6.0 seconds depending on how much data it has to work with. Over the past month or so it has started taking 30+ seconds after we do ...
2
votes
1answer
10k views

Does “use AWE to allocate memory” do anything on a SQL Server 2008 R2 64bit Windows 2003 system?

After checking the box I noticed that queries that would timeout after 30 seconds would complete execution. The TechNet article says "AWE is not required and cannot be configured on 64-bit ...
2
votes
2answers
987 views

Find which permissions are being used for a given user on a object

Is there any way in which I can see what permissions are being used to determine a users access to a given object? I'm able to see which permissions have been granted to various roles and users within ...
0
votes
1answer
284 views

How to create a trigger that update the date and time field and modify of the row

I want to create trigger that will update the record. The situation is like: I have one column named CheckInDateTime and one more named Status. If the administrator is not able to update the Status ...
4
votes
3answers
535 views

Is it possible to setup failover clustering between a 32 bit instance and a 64 bit instance?

I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008. One of the hosts I have is not capable of running a 64 bit ...
0
votes
0answers
526 views

Speed of one big insert vs multiple small inserts on SQL Server

I have a write-heavy application in which my initial testing has shown that one large insert into a table with four "large" columns is significantly faster than four inserts (in a single transaction) ...
2
votes
1answer
5k views

Any way to import-export-migrate-save-restore a maintenance plan without having SSIS installed (and running)? [duplicate]

I am having dozens of MSSQL Servers 2012 R2 on Windows Server 2008 R2 with similar setup, configuration (in virtual machines) in production. Neither has SSIS installed. I have to similarly maintain ...
0
votes
1answer
2k views

Linked Server Between SQL Server and iSeries is rounding decimals

We just set up a new SQL Server 2008 database, and I got the link set up between our server and an iSeries As400 server that we get some of our data from. The problem I'm having is that it is ...
3
votes
1answer
4k views

How Do I Troubleshoot Login Failed Errors In SQL Server?

What are some tips for troubleshooting SQL Server login errors? Questions like: How Do I see the full Error Message? My client just has a generic error message that says logon failed with no real ...
3
votes
2answers
392 views

How do I create a table with a column that uses a sequence?

I have the following CREATE TABLE [MyTable] ( [ID] [bigint] PRIMARY KEY NOT NULL, [Title] [nvarchar](64) NOT NULL ) CREATE SEQUENCE MyTableID START WITH 1 INCREMENT BY 1 NO CACHE ...
-2
votes
1answer
51 views

Getting user input [closed]

I try to get user input but I get an error and I'm not sure what to do,as I'm new into databases and according to w3schools this is the way to do it. vers = getRequestString("Give the version you ...
1
vote
1answer
811 views

Database failover/failback history

I am a SQL DBA newbie, and I am trying to get the failover/failback history for one of our mirrored servers. I am able to get the the failover history from event viewer but do not know how to the get ...
2
votes
0answers
236 views

Why use asymmetric keys in SQL Server?

I've been reading multiple resources on SQL Server Encryption, and everyone does it basically the same way, but no one explains why we use asymmetric keys in SQL Server. And by this I mean when we ...
2
votes
1answer
709 views

DbUp and script directory

I'm using DbUp, starting from the example I've created a C# program. The example suggest me to put all scripts under Scripts directory. Ok, this is done but, when script number will grow up that ...
2
votes
0answers
116 views

SQL Server is not started

I created the local service. My server name is like sqlitesync.com. In my database folder created the configuration (web.config) and WCF web service (AuroraSyncService.svc). When I test this service ...
4
votes
2answers
360 views

if database is not shrinked does it affect backup size?

Ok my question is simple. Lets say that when i click database and hover over shrink it says it can be reduced 1 GB space. Now when i do a backup of this database, does this space also getting added ...
-8
votes
1answer
146 views

What is the structure that SQL Server uses to build and maintain indexes called?

What is the structure that SQL Server uses to build and maintain indexes called?
1
vote
1answer
250 views

Extracting text from a column

I want to import data from Excel into an existing table in a SQL Server database. I have a column like Gender and the values are Male and Female in Excel. I want to insert only the first character ...
-3
votes
2answers
453 views

ROW_NUMBER() not working when adding DISTINCT [closed]

DEMO SELECT DISTINCT P_Master.P_Name,ROW_NUMBER() OVER (ORDER BY Visit_Date DESC,P_Master.P_Name ASC) AS RowNumber, (SELECT MAX(Visit_Date) FROM P_Visit v WHERE v.PID = p_Master.PID) as ...
0
votes
1answer
11k views

Cannot find either column “dbo” or the user-defined function or aggregate “dbo.fnDiscountPrice”, or the name is ambiguous

i have created fnDiscountPrice() that references the item id so that it will find the discount price for one item now I'm needing to find the total price of all the products with that ID. so i have a ...
4
votes
2answers
11k views

SQL join query to show rows with non-existent rows in one table

I am trying to get some reporting done for employee time records. We have two tables specifically for this question. Employees are listed in the Members table and each day they enter time entries of ...
2
votes
5answers
32k views

Backup and restore database - occured system error 5

In my work I made backup of database and I receive file .bak. Now I would like restore this database in my machine. But I get the following error: Cannot open backup device 'C:\Program ...
1
vote
1answer
6k views

Unexpected EOF during bulk insert

USE [campaigns] DECLARE @FILENAME varchar(400) = 'W:\PlayerListing\List.txt' ,@EMAIL_SOURCE varchar(50) = 'listing' ,@SQLCMD varchar(8000) PRINT (CAST(GETDATE() AS varchar(30)) + ' BULK ...
1
vote
0answers
65 views

'sa' Password Managment [closed]

I have been asked about my ideas regarding how often to change sa passwords and how best to manage this process. Users who are sa by right of user role are managed by the general password policy of ...
1
vote
0answers
416 views

SQL Error 3183 on SQL Server 2012

I have a backup of database version SQL Server 2008 R2. While restoring it to SQL Server 2012 I am getting error: msg 3183 RESTORE detected an error on page (6100:1886858449) in database ... . ...
2
votes
0answers
199 views

plan_generation_num keeps incrementing, why?

I have a query that is executed using sp_executesql code is as follows DECLARE @rsk NVARCHAR(1) = '1', @ppCityID NVARCHAR(3); SET @ppCityID = CAST(@cityID AS NVARCHAR(3)); exec sp_executesql ...
5
votes
3answers
3k views

Creating a read only replica of SQL Server database for reports

I've faced a problem when my .Net web application is running slow, even when I've optimized all queries. As it turned out another developer, who is making reports runs a bunch of non optimized queries ...
10
votes
4answers
30k views

Is there a way to generate table create script in TSQL?

Is there a way to generate a create script from an existing table purely in T-SQL (that is without using SMO, since T-SQL does not have access to SMO). Let's say a stored procedure that receives a ...
2
votes
1answer
68 views

Can SQL Server WebAdmin degrade the performance of my site?

Once upon a time a had to use the Parallels WebAdmin interface. After contacting the support team that hosts my website and informing them that I must use the Webadmin, they informed me that: MS ...
2
votes
1answer
25k views

How to extract the last inserted row in SQL Server?

When an insert statement is executed one or more rows is inserted into the table, is there any way to extract the last inserted row in SQL Server?
4
votes
3answers
1k views

Why is SQL Server 2012 Recommending This Index Be Created?

I have the following query: Select SubId, Max(ReadTimeLocal) From dbo.PanelWorkflow Where ProcessNumber IN ...
1
vote
0answers
21 views

Why is SQL Server Recommending I Create this Index? [duplicate]

I have the following query: Select SubId, Max(ReadTimeLocal) From dbo.PanelWorkflow Where ProcessNumber IN ...
1
vote
1answer
84 views

Mount mdf file to sql server desktop edition

I'm trying to attach a .mdf file to a SQL Server Desktop Edition. After reading this I connected to the database using the osql -E -S servername\instancename command. I tried to attach the ...
5
votes
1answer
11k views

Why aren't unsigned integer types available in the top database platforms?

Databases are usually very customizable with varying data types and custom lengths. It surprises me, as I try to look for the syntax to use unsigned int types that they are not available from neither ...
1
vote
1answer
406 views

Cannot grant execute to stored procedure [closed]

When I try to GRANT EXECUTE ON SP_NAME TO [DOMAIN\USER_NAME] on my database, I'm getting the error message below: Msg 8115, Level 16, State 1, Procedure grant_safety, Line 5 Arithmetic overflow error ...
0
votes
1answer
91 views

Namespacing database names on my server in order to test multiple different SSIS packages

An SSIS package that I'm building has two OLE DB connections, to databases named "core" and "staging". I created test versions of these two databases on my local SQL Server installation. I named them ...
4
votes
2answers
2k views

sqlpackage.exe ignoring BlockOnPossibleDataLoss?

I have a dacpac that has set the BlockOnPossibleDataLoss set to false, however the deployment is blocked when I run it with sqlpackage.exe, telling me "The column [a] is being dropped, data loss could ...
1
vote
2answers
1k views

Metric to standard unit conversion in SQL Server

I am giving simplified version of my two table which are as follow. tblRecords ID unit val --- --- --- 1 KV 3 1 BAR 4 2 KV 7 2 KG 5 3 C 37 tblUnit unit ...
2
votes
2answers
2k views

T-SQL - How to filter data from table

I'm new in DB world, so if you can help me it would be great. My problem: I have filtered some data and got a table with data, but need to filter them again. Picture might help you. For me, it is ...
2
votes
1answer
280 views

Logging errors with extended events excluding some users

I use extended events to store database errors, like this: CREATE EVENT SESSION [ErrorCapture] ON SERVER ADD EVENT sqlserver.error_reported ( ACTION ( sqlserver.client_hostname, ...
4
votes
2answers
13k views

DBCC SHRINKDATABASE TRUNCATEONLY 2008R2 vs 2012

Im a bit confused was the TRUNCATEONLY parameter changed in 2012 or is the documentation wrong in 2008R2? 2008R2 Releases all free space at the end of the file to the operating system but does ...
1
vote
1answer
347 views

Starting up sql server after hard-drive recovery

So I'm in a bit of a pickle. My primary work computer has recently crashed and some of the windows files were corrupted I tried repairing but did not work. This computer was running a program that ...
2
votes
2answers
9k views

How to read “CPU (ms/sec)” in the “Recent Expensive Queries” of Activity Monitor?

Is CPU (ms/sec) the cpu time in ms in previous second? If it reaches 1000, does it means that it uses 100% CPU? However, on my 8 cores server, the % Processor Time is usually very low like several ...
2
votes
2answers
721 views

Creating a partition on my soft-delete indicator column

In SQL Server 2008 R2 I am exploring the use of partitioning tables. We have a soft-delete scheme which is sometimes an IsDeleted bit NOT NULL and sometimes a DateDeleted date NULL I want to focus ...
1
vote
1answer
568 views

how do I check the last time dbreindex or an index defrag was executed

Is there a quick tsql I can use to check when was the last time a dbreindex, index defrag and update stats was executed on the database? Appreciate everyone's quick response.
-1
votes
2answers
543 views

Insert into an empty table with or without clustered primary key? [closed]

I will need to insert some rows in an empty temp table. The table has PK of (month date, id char(10)). The source table is partitioned by month. Which of the following is faster? 1a) the target table ...
4
votes
2answers
231 views

Central Management Server - can it manage itself?

I'm setting up a SQL Server 2012 lab on Windows 2008 R2 which has 5 SQL Servers. I registered SQL1 as my central management server and created a group under this server that includes all the servers ...