Viewing 15 posts - 1,666 through 1,680 (of 1,962 total)
Gail, what do you mean by "one off shrink"? Is that sort of like watching the growth of the transaction log file, and if it gets big then shrink it?
Kindest Regards, Rod Connect with me on LinkedIn.
February 29, 2012 at 12:44 pm
OK, it definately looks like shrink the database files is not a good idea. I get that.
How about shrinking the transaction logs? Even the linked to article by...
Kindest Regards, Rod Connect with me on LinkedIn.
February 29, 2012 at 9:46 am
sengeet86 (2/25/2012)
Check this.http://www.sqlskills.com/blogs/paul/post/why-you-should-not-shrink-your-data-files.aspx
Thank you for this.
Kindest Regards, Rod Connect with me on LinkedIn.
February 28, 2012 at 8:44 am
Thank you, Jeff, for that handy SQL script. I've saved it. Right now I ran it on our test database server. The growth precentages (the last column...
Kindest Regards, Rod Connect with me on LinkedIn.
February 28, 2012 at 8:41 am
I'm restricting myself to only the movies I've seen, which are also nominated for Best Picture in the 84th annual Academy Awards. I've seen The Artist, Hugo, The Help...
Kindest Regards, Rod Connect with me on LinkedIn.
February 24, 2012 at 8:58 am
I admit to being one of those people who is intolerant of failure on my own part. It isn't a good trait, but there it is.
However, I want to...
Kindest Regards, Rod Connect with me on LinkedIn.
February 22, 2012 at 8:55 am
What a nice post, Steve, thank you! And I echo it; I've gotten lots of help from this website and these forums over the years. And I learn...
Kindest Regards, Rod Connect with me on LinkedIn.
February 14, 2012 at 8:39 am
jcb (2/14/2012)
Jeff Moden (2/13/2012)
...Heh... even without that bit of nightmarish code, I still find the same to be true... "sad bugs" and "bad coding".
Sure, someday I ill print "I see...
Kindest Regards, Rod Connect with me on LinkedIn.
February 14, 2012 at 8:27 am
Thank you, I'll take a look at that blog.
Kindest Regards, Rod Connect with me on LinkedIn.
February 10, 2012 at 10:03 am
OK, right off I've got to tell you that I'm not familiar with Report Server Configuration Manager.
So, I got into it on the report server. On the left side...
Kindest Regards, Rod Connect with me on LinkedIn.
February 10, 2012 at 9:27 am
Jack Corbett (2/9/2012)
The URL for the pretty SSRS interface isn't http://servername/reportserver it is http://servername/reports. That drives me insane as well.
Oh, interesting, I didn't realize. Thank you...
Kindest Regards, Rod Connect with me on LinkedIn.
February 10, 2012 at 8:10 am
meridius10 (2/3/2012)
Which should I use in SQL Server 2008 R2, or are they both different/both need...
Kindest Regards, Rod Connect with me on LinkedIn.
February 3, 2012 at 9:13 am
Thank you, Randy Rabin and GSquared, for giving me code examples using semicolons, especially with respect to keywords like BEGIN and END. I'll start using semicolons in more of...
Kindest Regards, Rod Connect with me on LinkedIn.
February 2, 2012 at 1:09 pm
Gary Varga (2/2/2012)
Rod at work (2/2/2012)
Kindest Regards, Rod Connect with me on LinkedIn.
February 2, 2012 at 10:16 am
Semicolons will at some point be required in T-SQL? Really? I've seen it used in some cases, but am completely uncertain as to when they are to be...
Kindest Regards, Rod Connect with me on LinkedIn.
February 2, 2012 at 9:18 am
Viewing 15 posts - 1,666 through 1,680 (of 1,962 total)