Viewing 15 posts - 91 through 105 (of 820 total)
We have been looking for key changes as a cause for index changes. What if there are no key changes at all? I'm betting that there are no...
January 27, 2015 at 12:55 am
Eric M Russell (1/26/2015)
January 26, 2015 at 12:34 pm
Nice article Ben. Thanks. I had often wondered about some of these super complex queries that I have seen. Why is that alias there? This makes...
January 26, 2015 at 11:04 am
Usually I'm the odd one out. It's comforting to know that I have been taking the reasonable course the whole time. The database is the foundation and the...
January 26, 2015 at 10:44 am
Eric the folks in the UK just went, "What?". Over there "biscuits" means something else. However free food and coffee is likely to clear out a data center...
January 23, 2015 at 9:02 pm
Thanks Jeff. No actual test data but you would be right in presuming that if you change the type of a column that is indexed, either as the key...
January 22, 2015 at 12:11 pm
Ic guess its funny that my experience is upside down from the rest. I've had better results when I go in someplace cold. I love design conferences.
"Folks we...
January 22, 2015 at 11:46 am
Understanding the way that SQL Server stores things is very helpful in understanding why some table alterations seem to take no time at all and other will bring the server...
January 21, 2015 at 6:37 pm
Sean Lange (1/16/2015)
TomThomson (1/16/2015)
Sean Lange (1/16/2015)
TomThomson (1/15/2015)
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
January 17, 2015 at 5:38 pm
To drive home the point that Jeff was making you can look at the PCs that your users are running. If the application lives on the desktop then for...
January 14, 2015 at 12:23 pm
I have not had my coffee yet but I thought that on recent versions of SQL server that TempDB was cleared each time the instance started. Might it take...
January 14, 2015 at 11:33 am
Great QOD Steve. I would have not thought that this would have that many issues.
Seems that COUNT() does some fun things. I have been using COUNT(1) to mean...
January 14, 2015 at 11:19 am
At one company where I worked the development team worked for the support manager. This worked very well as our top priorities were to put in code to make...
January 12, 2015 at 3:10 am
At one company in a staff meeting it was said, "We don't prevent the user from shooting themselves in the foot. Rather we sell them a LASER sight." ...
January 7, 2015 at 4:54 pm
ScottPletcher (1/2/2015)
GilaMonster (12/31/2014)
Luis Cazares (12/30/2014)
Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.
It's also far less clear than a DATEADD...
January 6, 2015 at 11:01 am
Viewing 15 posts - 91 through 105 (of 820 total)