Viewing 15 posts - 166 through 180 (of 371 total)
SQL Kiwi (1/11/2012)
January 11, 2012 at 8:18 am
Such an easy question that feels refreshing and points out an excellent feature for international dates.
Thank you, Steve, Hugo and Mark for the additional explanations and opinions.
Best regards,
January 10, 2012 at 9:04 am
This has to be the best article I've read about traces ever.
Please keep them coming with real world examples like the one from Listing 5 and 6.
Much appreciated.
Best regards,
January 7, 2012 at 3:30 pm
Thank you, Hugo. I'll keep that all in mind and I will do some tests in my development server.
Best regards,
January 7, 2012 at 10:02 am
Thank you for the question.
A related question of you allow me (I didn't want to create a topic):
What are the main advantages of using a backup compression over using a...
January 6, 2012 at 2:33 pm
Saggy (12/24/2011)
2. Can we run a full backup without interrupting LSN(Log Sequence Number) ?
I'm not sure if that's what you want but you can use BACKUP DATABASE <etc.> WITH...
December 25, 2011 at 7:05 pm
WILLIAM MITCHELL (8/17/2007)
<A href="http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php">http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php</A>
Could you please explain?
Best regards,
December 24, 2011 at 9:14 pm
Guys, it's Christmas! Just that, Christmas. C'mon... 😛
Merry Christmas.
Best regards,
December 24, 2011 at 9:10 pm
Oh, and Merry Christmas to all of you!!!
Sorry for the double post but I thought this message needed its own post. 🙂
Best regards,
December 23, 2011 at 3:58 am
I think they don't mean that people will "eat reindeers" over the weekend but more likely it's associated with Santa Claus's transportation. 😀
But it took me a while to dismiss...
December 23, 2011 at 3:56 am
I'd say that if you study SQL Server 2008 R2 material it will still be valid for the new certifications (unless you're talking about Training Kits which may become outdated...
December 10, 2011 at 9:09 am
You can have WHO and WHEN available to you using CT with the CHANGE_TRACKING_CONTEXT method posted in one of my last posts. Storing WHAT changed would be limited by the...
December 5, 2011 at 7:54 am
Or maybe use a loop "WHILE @@TRANCOUNT > 0 ROLLBACK TRAN..." or something. 🙂
Sorry for the double post. I clicked the wrong button.
Best regards,
December 2, 2011 at 9:32 am
Hi, Carl.
You could use it to make sure that the transaction will be either committed or rolled back when the script ends. There won't be a missing COMMIT TRAN after...
December 2, 2011 at 9:29 am
Viewing 15 posts - 166 through 180 (of 371 total)