for SQL Server 2005, major build version 9.00.xxxx.
-2
votes
0answers
28 views
Best Isolation Level to avoid deadlocks in SQL Server
I need to execute an update statement over a SQL Server table. This table is used by another process at the same time. Because of that, sometimes deadlocks occurs. Which isolation level do you ...
1
vote
1answer
6 views
Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection
I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode.
The page verification is set to TORN_PAGES detection.
So, far the backup has been corrupted when we ...
1
vote
1answer
38 views
Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
I am trying to create an INSERT script to salvage data from a single table in a corrupt database.
I've succesfully put the database online and put it in EMERGENCY / SINGLE USER mode (following this ...
7
votes
2answers
245 views
Is adding index on bit column significantly slow down inserts?
I have a table with about 1 million to 5 million records. Small part of that records have one of bit column set to 'TRUE'. Need to fast find that records. I think that index can speed up searching on ...
1
vote
0answers
25 views
In SQL Server sp_cursorprepare/sp_cursorexecute run extremely slowly
I'm running an application (Pentaho user console with the Saiku Ad-hoc plugin) which creates a query and runs it using sp_cursorprepare & sp_cursorexecute standard stored procedures.
My model is ...
0
votes
0answers
19 views
Master Slave Databases and their architecture
We are currently using Sql Server 2005. We currently have separate databases for different instances of our application. The application is a heavy in terms of data and processing.
We now want to ...
2
votes
1answer
25 views
SQL Server Merge Replication Dummy Update issue
We have SQL Server 2005 SP4, using merge replication.
We started getting this error when the subscribers try to replicate (not all of them but most):
The process could not deliver dummy update ...
1
vote
2answers
64 views
Does RAM taken up Shared Memory connection counts against Max Server Memory?
I have an app that's local to the SQL Server and thus has a Shared Memory connection to it. I was wondering whether the RAM taken by the connection (including data transfers) counts against the max ...
2
votes
3answers
104 views
Is there a way to execute sql statement in sql server based on sql server version?
I would like to create computed index on a table if sql server is 2008 or newer and a simple index if sql server is 2005 or older:
-- check for sql server version
if (select ...
0
votes
0answers
27 views
linked server to a network csv file
I am trying to create linked servers from SQL 2000 and 2005 to a network share csv file. I am using Microsoft Jet 4.0 OLE DB Provider with "text" as the provider string.
With regards to security, I ...
3
votes
0answers
48 views
Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?
I have an app (windows service) local to the SQL Server box. It calls a sproc on the SQL Server box that returns a ton of data and thus causes ASYNC_NETWORK_IO wait.
The database connection from is ...
1
vote
1answer
76 views
Query that displays backup information (successful and failed) SQL Server
I have two jobs that backs up two different databases.
Job 1 backs up DB1
Job 2 backs up DB2
DB1 fails to back up due to low space on Drive 1 resulting to a Job 1 failure. To fix that issue, I just ...
0
votes
2answers
86 views
c# Backup sql server database, error Operating system error 5(Access is denied.)
I have been trying to backup an sql server database, and I understand that this error is in regards to drive write protection. I am at the end of my rope with this, as nothing that I have found online ...
2
votes
0answers
46 views
backup history script produces incorrect results
I have a database that is backed up via maintenance plan. The database is scheduled to be backed up at 8:00PM. It usually takes 6 hours to complete. According to this query,
SELECT
distinct ...
7
votes
1answer
111 views
Necessary to include clustered index columns in non-clustered indexes?
Considering that a non-clustered index is based on the clustered index, would it be necessary for the non-clustered index to list any of the columns contained in the clustered index?
In other words ...
4
votes
1answer
83 views
Is ASYNC_NETWORK_IO wait type anything to worry about?
In looking at the list of sprocs that take long time to execute, one stands out as causing the most wait. However, most of that wait (81%) is ASYNC_NETWORK_IO and I know why: the sproc transfers ...
0
votes
0answers
39 views
SQL Server Replication do not replicate DELETE statement
We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc.
From A to B we have ...
3
votes
1answer
119 views
How to improve Procedure Cache Hit Ratio?
From what I can tell Procedure Cache Hit Ratio below 95% is a problem. On my box, the values hover from 85 to 95%.
How do I fix this issue? The server seems to have plenty of RAM so that ...
1
vote
1answer
48 views
Linked Server Has Run Out Of Memory
So I have a stored procedure that calls an AS400 Linked server. Now, the stored procedure will execute successfully. However, it is used in a SQL Agent Job and each time the job runs, it gives the ...
1
vote
1answer
52 views
How do I find out if Sql server Agent's login has rights to a DB?
How do I find out if the SQL server Agent's login has rights to the target DB, that is the DB on which I will be executing a query ?
Also, how do I find the service that's controlling Agent on the ...
4
votes
2answers
200 views
Issues with TempDB mdf file ever increasing
I have a tempdb growth issue. Let me preface everything by giving my tempdb settings.
Even with no queries running on the database/server tempdb keeps on increasing in size, at first rapidly and ...
0
votes
2answers
46 views
Combine tables only if no results
We have a table FOO that has a huge amount of data in it, most of which is only used infrequently and by (slow) user-interaction.
We would like to move all data that is more than 12 months old to an ...
1
vote
1answer
142 views
'Tempdb' is full warning message in SQL Server 2005
I am using SQL Server 2005. it's a running plant, Everyday large number of data posted into SQL Server 2005
SELECT
TOP 5000 [T_idx], [T_TAG], [T_Date]
FROM
[house].[dbo].[total]
ORDER BY
T_Date ...
1
vote
1answer
51 views
Tool for identifying stored procs with deprecated syntax?
I have to move a DB running in compatibility mode 80 (SQL Server 2000) on a SQL Server 2005 to a SQL Server 2012. How can I scan it for stored procedures that might break due to deprecated or ...
2
votes
1answer
58 views
SQL Server 2005, non-yielding scheduler Spinloop on Snapshot
I was running dbWarden's procedure for CheckFiles on my server.
The job never ended and my logs started to fill up with message at a rate of 1 per minute: 2014-01-07 08:40:04.07 Server Process 58:0:0 ...
0
votes
1answer
36 views
How to move SQL server transaction replication from one server to another server [on hold]
Currently we have SQL Server 2005 as a publisher and SQL 2008 R2 as subscriber for one of our database (about 350 GB in size).
I want to move the replication to our different server (Which also has ...
3
votes
0answers
45 views
Any checklist/guide when transferring a database to a new server? [duplicate]
I'm looking for steps that I need to follow to transfer a database to a new server. So far I have:
I restored the current database that I have in SQL Server 2005 instance to another SQL Server ...
2
votes
3answers
130 views
Attempting to restore SQL Server 2005 database to a SQL Server 2008 R2 instance gives reason: 15105 error
I have a SQL Server 2005 database I am attempting to restore a SQL Server 2008 R2 SP2 machine using this statement:
RESTORE DATABASE [Db]
FROM DISK = N'C:\temp\sql\DB.bak' WITH FILE = 1,
MOVE ...
0
votes
0answers
39 views
SQL Server Reporting Services Upgrade/Migration
I couldn't find any documentation on this. I'm currently doing a dry run of SSRS 2005 to SSRS 2008 R2 upgrade/migration. I've backed everything up (encryption key and configuration files) and did a ...
3
votes
1answer
36 views
Implement Log Shipping in prod env
We have a 3.5 TB DB which is already involved in log shipping to two different servers, as one will be in restore sate only and one will be in stand by mode which helps for reporting needs. All three ...
6
votes
1answer
209 views
How to move a database from SQL Server 2012 to SQL Server 2005
What are my options if I need to move a database from SQL Server 2012(32bit) to SQL Server 2005(64bit)?
I know I cannot:
restore a backup of the database on SQL Server 2005
detach & attach
I ...
1
vote
2answers
103 views
How can I run this SQL query across all of my databases at once?
I have a query to let me know basic info on backups. I have several SQL servers that I'd like to be able to query at once. Is it possible to run the following query across several servers at one time? ...
0
votes
1answer
61 views
Help with Transferring Linked Server to another server?
Please advice me as I'm trying to move the linked server (Providers with the tables in Catalogs) from SQL server 2005 to another upgraded sqlserver 2008, I scripted out everything from there, but not ...
0
votes
0answers
71 views
How to determine if SQL Server Reporting Services database is being used?
I have a SQL 2005 server that needs to be decommissioned. For regular databases, I have a couple scripts that look at sys.dm_db_index_usage_stats to determine last access. My normal process is to make ...
1
vote
1answer
93 views
Why isn't SQL Server using the Max Server Memory setting?
I have a SQL Server machine with the following:
Windows 2003 Enterprise SP2 (32-Bit)
SQL Server 2005 (32-Bit)
12GB RAM
/PAE switch set in boot.ini
6 SQL instances, all with AWE enabled
No other ...
1
vote
1answer
40 views
How to disable data type check while pushing data to Linked Server
I have two SQL serves one is SQL server 2005 and other SQL server 2008.I push data from SQL server 2005 to SQL server 2008 using Linked Server.I want to improve performance of data transfer. Few days ...
1
vote
1answer
56 views
SQL Server Login attempts fail when using SSMS but succeed when using SQLCMD
I have my SQLServer 2005 instance configured for mixed mode fine. When using SSMS, none of the sql server logins seem to work. Just "Login failed for user '..'" message. But when I use SQLCMD, it ...
2
votes
1answer
89 views
Performance issue with TOP (1) on a nullable column
I need help to identify the reason for a performance issue.
Actually following query sits in a scalar-valued-function but that is not the reason for the issue since it needs the same time as query:
...
35
votes
3answers
165 views
Huge slowdown to SQL Server query on adding wildcard (or top)
I've got a zoo of 20 million animals which I track on my SQL Server 2005 database. About 1% of them are black and about 1% of them are swans. I wanted to get details of all the black swans and so, not ...
0
votes
0answers
29 views
SQL Server 2005 Create a SQL Server failover cluster check button is not enabled
I try to install SQL Server failover cluster under windows 2003 or windows 2008. In both installing time I found the checkbox enable error. I don't know any changes want to do to windows server before ...
0
votes
1answer
80 views
Shrink Database Did Not Reclaim Much Space
I have a SQL Server (2005 Developer Edition) database that has grown too large for it's drive.
Yesterday evening I dropped a large table that was no longer needed and last night I set up a ...
0
votes
1answer
32 views
Joining 2 tables- in Select statement show how many fields matched directly (A1 = B1), vs matched on isnull(A1,B1) = B1
I have 2 tables which I need to join,
but sometimes there are
1) direct joins e.g. t1.FieldA = t2.FieldA
OR
2) when t2.FieldA is null then it must join as well then t2.FieldA is null t1.FieldA = ...
2
votes
1answer
94 views
SQL Server Linked Server error and Query Problem
I am having two servers running SQL2000 and SQL2005.
There is a database A,B in SQL2000. Similarly i have the same in A,B in SQL2005. A,B are name of the database.
I have a linked server pointing ...
0
votes
1answer
36 views
Linked SQL Servers
I'm trying to link 2 SQL Servers (2008 and 2005). I have tried it via the GUI and scripts, and having no luck. I have problems trying to to query through it with access. As I'm not the Admin of the ...
0
votes
0answers
92 views
sql serer 2005 installation windows 8 64 bit
sql serer 2005 installation problem in windows 8 64 bit
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log ...
0
votes
0answers
132 views
SQL Server: Batch Requests/sec showed increase in performance, but performance actually decreased
We are currently on SQL Server 2005, with a plan to move to SQL 2012. To make this move we have to test new database drivers for the application (Java). We performed 2 load tests using the 2 different ...
1
vote
1answer
62 views
User switching accounts, can't log into MS SQL Server anymore [closed]
First a bit of background, for good or bad, we don't keep one user account attached to one person. The user accounts are matched to their position. For instance the CEO would have a userid of CEO. ...
3
votes
1answer
48 views
Advice on setting up a Reporting server
I'd like to ask advice on setting up a reporting server please.
We have a SQL Server (on a VM) that handles operations. (SQLOps)
This primary SQL server instance has a secondary Log Shipping ...
1
vote
3answers
136 views
GUID stored in a varchar field
I have inherited several databases that use GUIDs as PKs. Instead of all the datatypes being uniqueidentifier most are varchar(50) and some varchar(100). Fields are true GUID some where created by
...
0
votes
2answers
53 views
SQL Server 2005 Replication Stops after a minute without an error
Background:
I have a SQL Server 2005 setup with master, slave1, slave2 replication set up as a pull replication from slaves. The distribution database resides on the slave1 machine, both slaves pull.
...
