Topics
Started by
Posts
Last post
I've table as following, CREATE TABLE [dbo].[myTbl1]( [idx] [int] IDENTITY(-2147483648,1) NOT NUL…
6 replies
I have a report that runs twice per day, its expensive, when cached its much quicker, however the p…
16 replies
Hi, I have attached my query and execution plan. I have tuned the query according to suggested by t…
4 replies
How to do Select Count with critria from a big table (40,000,000 records)? This is very very slow !…
10 replies
Hi, I'm a beginner in Execution Plan. Can someone tell me what's the Query Cost means? Part of the …
4 replies
Hi All, Normally, differential backups takes min 50 mins to max 02 hrs 30 mins in one of our db ser…
3 replies
We have a rather busy production server which is running SQL2005 SE 64bit on Windows 2003 64bit. Th…
4 replies
How can I read LDF file? My table is missing from database, and I want to know how it has been remo…
6 replies
My current code as following, Dim sqlNm As String = "" Dim sqlNm2 As String = "" D…
5 replies
I am running a query against sys.dm_exec_requests to look a query that is currently running. I can…
2 replies
Dear All, I have an issue regarding the procedure tuning. I tuned one procedure which retrieves 6la…
7 replies
Hi, Is that correct that Table Partitioning will be available in Sql server Developer and Enterpris…
7 replies
Hi All, I would like to know whether the usage of VARCHAR(MAX) intead of using VARCHAR(fixedlength)…
14 replies
Just thought I'd add this as a warning to anyone adding indexes or writing procs. What happened was…
6 replies
I'm not sure if this should be here on the TSQL forum but anyways, I'm working on this query and wh…
3 replies
Viewing 15 topics - 391 through 405 (of 3,249 total)
You must be logged in to create new topics.