Viewing 15 posts - 1 through 15 (of 275 total)
Thanks Bevan! Seems that order clause fixed the issue. Look like the output is now correct.
February 20, 2018 at 8:56 am
Same thing here. I used the code attached to the article, and the result set has almost all initial values replaced with other values and the results is not valid...
February 20, 2018 at 6:47 am
Very interesting Bevan! Thanks for article. Can't wait for next part!
February 20, 2018 at 5:08 am
To tripple-check, I just tested in on a 75K character long SP and it printed out just fine. If you look at the code, it dynamically makes sure a CR+LF...
January 22, 2015 at 9:35 am
David, I believe the code I posted does not have that problem. I routinely use it when I need to recover some code that was updated.
January 22, 2015 at 9:27 am
Great article. We have been using DDL Loging for quite some time, with different iterations of T-SQL scripts.
And, there is a way to circumvent the PRINT limitation on length and...
January 22, 2015 at 8:42 am
We have deployed several VM clusters with SQL 2012 on VMWare, and there's some caveats to it. If you want to use shared storage it basically breaks, at least for...
November 28, 2013 at 7:24 am
Brent Ozar (1/15/2013)
January 15, 2013 at 6:36 am
jeffreddy (1/10/2013)
SQLDBA360 (1/10/2013)
I've never had any problems setting SA as the DB owner with the SA account disabled, its a practice I follow even when the...
January 10, 2013 at 8:38 am
winash (10/21/2010)
Googled this out of curiosity and found the most disturbing explanation for index segmentation...http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
:ermm: :alien: :w00t: - looks like a "WTF!!??!!" icon is needed
ouch... and someone googling that will...
October 21, 2010 at 1:31 pm
TemDB will not automatically shrink back, but you need to take something bigger in consideration: how often will this happen? If it will be frequent, it would be best to...
October 19, 2010 at 1:22 pm
Carlo, nice try with this Question of the Day, but I really learned more with Hugo's explanation......
October 12, 2010 at 7:55 am
Great review.
We have been using SQLdm for quite a while now, focused on our main application and its DB server and it has provided timely and invaluable help...
October 4, 2010 at 10:23 pm
Run this against your msdb and it will give you an idea what tables are the big ones. If the sum of the ReservedKB column is not adding up close...
September 29, 2010 at 10:15 am
Viewing 15 posts - 1 through 15 (of 275 total)