Viewing 15 posts - 16 through 30 (of 819 total)
Great article David.
It shows how difficult it can be to come up with ways to automate what a human should be doing.
January 26, 2016 at 4:11 pm
GoofyGuy (8/7/2015)
Online video gaming?
At one point we would take a hour out of the day an do first person shooters at our desks. Those that were out of office...
August 7, 2015 at 2:03 pm
Great article.
I want to thank you for something else though. You put all of your scripts into a file and included it rather than leaving it to be copied...
July 28, 2015 at 5:58 pm
Iwas Bornready (7/28/2015)
I don't get it.
It's a quote from a Jim Henson film called "The Dark Crystal[/url]".
In the film there was a fractured crystal (the MacGuffin). There was a...
July 28, 2015 at 10:01 am
I'm a bit late to the party but ...
Just because Microsoft does it it or does not do it is no excuse for me to do it or not do...
June 5, 2015 at 7:19 pm
I like to have my main data files and log files on different physical drives. Your script will put all of the files for a database in the same...
May 30, 2015 at 3:02 pm
The new guy? Typically it is the new guy who thinks that the manager is the one full of ...
May 29, 2015 at 9:08 pm
rasika.nanayakkara (5/29/2015)
I tried this example and found out that Excel and Word documents cannot open and it says they are corrupt.
Since I did not see any mention of file encoding...
May 29, 2015 at 3:51 am
The split password and side-by-side authentication reminds me of the old days under ground when we both had to turn our key at the same time. :w00t:
May 27, 2015 at 1:26 am
There is an oft quoted poem that I will re-quote here:
It is by caffeine alone I set my mind in motion,it is by the beans of Java that thoughts...
May 17, 2015 at 11:35 am
Good one Jason!
What version of SQL Server are you working with? Looks like even BOL can be wrong. Like I always say, "It could happen." 🙂
I had...
May 13, 2015 at 11:10 pm
Stored procedures cache the execution plan at the time the procedure is compiled. On the other hand a query may get a new execution plan every time that it...
May 9, 2015 at 3:48 pm
Thanks Gail. I had missed that point.
Toby, the O/S fragmentation does not have anything to do with the shrink. Actually it does not even apply to index fragmentation....
May 4, 2015 at 12:06 pm
TheSQLGuru (4/30/2015)
Hmm. Wouldn't adding a meaningful index to a table cause "affected" plans to recompile? Bit tired at the moment so could be confuzzled ... :w00t:
That would be so nice...
May 4, 2015 at 11:58 am
Viewing 15 posts - 16 through 30 (of 819 total)