Viewing 15 posts - 4,666 through 4,680 (of 5,841 total)
A spid can show as blocking itself - a 'feature' added in SQL 2005. IIRC it happens when a block of memory is latched and it blocks continued execution...
July 16, 2009 at 8:35 am
I would calculate the date you need with that math first and put it into a variable and use that. You will also need an OPTION RECOMPILE to ensure...
July 16, 2009 at 8:31 am
All of the locking and such will be automatically handled by sql server. Indexing will be key to efficient delete of the maintable rows, which will be critical to...
July 16, 2009 at 8:25 am
Where possible (which is the vast majority of the cases even if you need uniqueness across multiple machines - just use a compound key) I recommend to my clients that...
July 16, 2009 at 8:23 am
>>How I wish there was a sp_configure GO_MUCH_FASTER 1 setting to play with.
This configuration exists - and is known as hiring TheSQLGuru to give your system a performance review. ...
July 8, 2009 at 6:33 am
Depending on the size of the data, copying it all local and then doing the query could be significantly faster. This is especially true if you can restrict the...
July 2, 2009 at 7:34 am
jvElecenter (7/1/2009)
I know I give few info and I am asking a lot.
We are not running big queries. There are no deadlocks.
Database is running on disk, transaction log is...
July 2, 2009 at 7:28 am
+1 to Gail's comment about zeroing out large files.
Also, you stated 10TB of SATA drives - that is going to suck for performance. SATA drives are not nearly as...
July 1, 2009 at 1:28 pm
I agree with the others re IFI - if ultra-high security isn't a requirement I advise my clients to enable it.
I have had some clients on NetApp SAN's for SQL...
June 30, 2009 at 10:23 pm
>> negative faith
New term - I think I may like it! Although perhaps antifaith could be better. 🙂
June 30, 2009 at 10:18 am
1) I would imagine (hope) that the optimizer would choose the 'most-compact' covering index in the case where multiple indexes cover a query.
2) DTA and the missing index subsystem really...
June 30, 2009 at 9:33 am
1) forums such as this are for targeted, short problems where people that are volunteering their time can provide a solution in a matter of minutes. What you posted...
June 26, 2009 at 8:49 am
1) IIRC, Microsoft's recommendation is to not even bother defragging tables with less than 1000 pages
2) For sizeable tables, if you don't have sufficient free space in the database of...
June 25, 2009 at 7:38 am
Pretty poor that this value ISN'T stored and reused if you ask me - or even if you don't!! 😛
June 23, 2009 at 1:22 pm
tom.groszko (6/22/2009)
You said nothing about checking security. I still find SQL servers with a default blank password. Everybody who ever worked there has full access to the server.Tom Groszko
'Fixing' security...
June 22, 2009 at 9:03 am
Viewing 15 posts - 4,666 through 4,680 (of 5,841 total)