Viewing 15 posts - 46 through 60 (of 149 total)
Very interesting article and a great discussion generator. Many thanks.
...As a sole DBA at the place I work, I support over 50 SQL servers...
Anyone else notice the irony? :hehe: I...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 15, 2014 at 8:40 pm
What can we infer about the utility of this tool given that nobody's ever heard of it?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 27, 2014 at 1:03 pm
We've similarly avoided the use of the term "best practises" because there's always more than one way to skin a cat. Instead we've developed a SQL checklist. Before code goes...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 12, 2014 at 1:59 am
I don't care how cheap storage is or becomes, I hate wasting resources if they don't need to be wasted.
That's right. Laziness is looking at what the price used...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
October 29, 2013 at 4:03 am
Hi Dwain
Sorry for not getting back to you. I've been diverted to other projects for a while. I provided a rather simplified version of the problem as an example, but...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
September 3, 2013 at 11:32 pm
Chris how would you change yours to work on SQL 2005 (no cross apply and table value constructors)?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 15, 2013 at 1:51 am
Hi Dwain
I'm enormously grateful for the code you've put up. I'll test yours and Chris's and see what I can learn from them. I'll post back my observations after some...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 15, 2013 at 12:48 am
Awesome to have the heavy hitters on the case! Jeff, where you say:
You're not actually supposed to use any data from that. You're only supposed to use the presence of...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 15, 2013 at 12:26 am
OK. So I'm trying to understand table value constructors and cross apply. If I do this (on a SQL 2008 machine):
SELECT *
FROM...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 14, 2013 at 4:11 pm
Thanks Chris. I'll go away and digest it. The VALUES... syntax doesn't work in SQL 2005, but it looks suspiciously like a tally table (which I already have) so I...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 14, 2013 at 3:34 pm
(Don't panic - tongue is firmly in cheek here)
Wouldn't it be good if they created a licensing structure that forced db designers to normalise their OLTP databases properly. I'm heartily...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 7, 2013 at 3:48 am
A comprehensive discussion of the various options tried in the past can be found here:
http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
July 30, 2013 at 11:29 pm
Like Revenant, I too am a dev and not a DBA. I don't currently have access to a server that I can create dbs on, and faff around with backups...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
July 9, 2013 at 4:47 pm
Well, a lot has changed since 2008. BlackBerry! Who remembers that! Hilarious!
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
June 24, 2013 at 12:18 am
Hi adelinetfl.smkss
You can increase the number to something greater than 100. Not advocating anything here 🙂
See Query Hints in SQL Server Books online:
...MAXRECURSION number
Specifies the maximum number of recursions allowed...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
June 17, 2013 at 11:50 pm
Viewing 15 posts - 46 through 60 (of 149 total)