Viewing 15 posts - 39,256 through 39,270 (of 49,571 total)
RBarryYoung (5/7/2009)
May 8, 2009 at 1:59 am
Dean Jones (5/7/2009)
true talk herebut sometimes, the Query can look long winded and kind of long, and hence the reason why its been put into a temp table.
Long winded and...
May 8, 2009 at 1:54 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
On SQL 2005, take a look at the...
May 7, 2009 at 1:19 pm
Busy database? If you get a lot of transactions/sec, that's easily doable. I've had one that generated 500MB in half an hour, and that was a datawarehouse-type DB. If that's...
May 7, 2009 at 1:04 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic712281-148-1.aspx
May 7, 2009 at 11:57 am
Alex Prusakov (5/7/2009)
Also, never ever use SELECT DISTINCT if you want good performance.
I wouldn't say never. There are times when it's needed, when you do really need distinct data...
May 7, 2009 at 11:54 am
No one's suggesting that you enter IP addresses manually. The Table variable that Lynn and Flo had in there code was a substitite for the real table. To implement their...
May 7, 2009 at 11:12 am
Dean Jones (5/7/2009)
May 7, 2009 at 11:04 am
Grant Fritchey (5/7/2009)
May 7, 2009 at 11:02 am
Lynn Pettis (5/7/2009)
You can query the t-log??
Yup. Undocumented command.
SELECT * FROM fn_dblog(null, null)
The two parameters are starting and ending LSNs. Good luck deciphering it. Tran log's not exactly 'readable'
For SQL...
May 7, 2009 at 10:05 am
Either there's a job that has a command in it to change the recovery model, or someone ran a command to do it directly. SQL won't automatically change recovery models.
There...
May 7, 2009 at 9:47 am
No formal process.
If I'm considering the indexes from missing indexes DMV, first I'll make sure there are no partial redundancies within the index recommendations. I'll also make sure that there...
May 7, 2009 at 9:33 am
Dunno if you noticed, but I asked the question almost a year and a half ago.
What I ended up doing was querying the tran log before each backup, looking for...
May 7, 2009 at 9:32 am
CheckDB uses a database snapshot anyway. Running it against a snapshot is not going to make any difference. It doesn't take any locks as it works (and never has), and...
May 7, 2009 at 9:29 am
How often are you running CheckDB at the moment?
May 7, 2009 at 8:31 am
Viewing 15 posts - 39,256 through 39,270 (of 49,571 total)