Topics
Started by
Posts
Last post
We have recently started seeing our daily maintenance plan causing performance problems. Specifical…
20 replies
I'm seeing an issue that baffles me so I'm hoping someone can confirm my suspicion. I have a query …
11 replies
Hello, I have an encrypted view that, when I do a select on, takes over two minutes to return data.…
2 replies
Does anyone know for certain if SQL 2005 supports the nolock hint on a plan guide? Gettting…
3 replies
Dear All, While creating tables, few people in my office always select NVARCHAR as datatype.c…
7 replies
Hi I am running SQL Server 2005 x64 sp4 on Windows Server 2003sp2 x64 in production. (8gb sql serve…
8 replies
hi all, Do any one have any script by which i can get a automatic email notification when a HIGH CP…
6 replies
Hi, The below query is taking around 1000 Seconds.SELECT ar.MOVE_QTY,ar.DM12,ar.AL_OR,ar.OR_CODE,ar…
10 replies
I am not DBA by any means but i am keen to understand more about DBA side and how i can improve per…
1 replies
I need help to Query optimization.Query is part of StoredProcedure which executes for more tha…
8 replies
I have an old SQL 2005 server we are currently migrating away form that has suddenly started under …
10 replies
Does anyone have any opinions concerning the performance of Float vs decimal data types? For exampl…
30 replies
Hi All, I need last business day from a table with ID,date and day column in it. For e.g. IDDate …
5 replies
So we have a situation where an application does an item lookup. On average that item lookup calls …
5 replies
Dear All, My Database is SQL Server 2005. It is having 32Gb ram. In which Sql server taking 28 gb. …
3 replies
Viewing 15 topics - 1 through 15 (of 3,249 total)
You must be logged in to create new topics.