Topics
Started by
Posts
Last post
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
When looking at the execution plan of a query it shows a 'Clustered Index Update' @ a cost of 85%. …
12 replies
when i execute my main sp , inner sp showing read count as 6000 ,but when execute that perticular …
5 replies
Viewing 15 topics - 1 through 15 (of 3,249 total)
You must be logged in to create new topics.