Topics
Started by
Posts
Last post
I use nvarchar field to identify records in a database table due to an Identity Field is used as Pr…
10 replies
Hi, I have a recursive query which is very slow. AS this is a dataware housing ENV, We will not cre…
11 replies
Hi, I want to give a non-sysadmin user permission to backup and restore a database. I have tried to…
2 replies
I'm new to a company and started going through some index usage using the system DMs (dm_db_index_u…
1 replies
Hi Everyone, I have enabled the AWE for our SQL Server EE 2005 on Windows Server EE 2004. The Total…
3 replies
Hi I have a master-detail join and when I query for master_id, all well, but when I query for detai…
5 replies
Dear All, I have "Execute " right for a procedure in another database. I dont have any other contro…
5 replies
Hello I recreated indexes on one of my tables. I have a clustered index on the ID field - PK I also…
15 replies
Hi All, We have unique performance problem with across database queries and DML operation on our d…
2 replies
OK, Here is the problem. I have a SPID that is blocking itself and presently in a state KILLED/ROLL…
4 replies
Hi, I was reviewing some code in our current system and came across a stored procedure with a bunch…
2 replies
I am running SQL Server Std 2005 sp2. I have an 2.1M row, 88g table with a single clustered PK inde…
1 replies
Hi, What do we need to proceed with if Queries getting timed out? What are changes i must make to m…
15 replies
hello, could any one plz say me how to save a performance dashboard report to excel..thx
2 replies
declare @A int,@B int select @b-2 = 3041 if @A is null select '@A is null' if (@A <> @b-2…
5 replies
Viewing 15 topics - 2,311 through 2,325 (of 3,249 total)
You must be logged in to create new topics.