Viewing 15 posts - 1 through 15 (of 73 total)
The article is an interesting, alternate look at indexing. Your strategy is about indexing for performance, and I guess I recognise that that need can vary with the same...
June 26, 2014 at 6:14 pm
I'm not sure if I already said this in the thread, and it's a minor point, but I am not sure that int is the best thing about SQL Server...
November 3, 2009 at 3:15 am
Incidentally I recently created a view around OPENQUERY() - data coming from a linked server. Which may have been not the best way to do what I was doing....
October 29, 2009 at 7:46 am
Dream Weaver (10/5/2009)
October 6, 2009 at 8:19 am
Rowland Gosling (10/2/2009)I was a little kid when that happened. We were a space family.
Rowland Gosling (10/2/2009)
I assumed that was why you didn't jump on the "we got to the Moon no...
October 2, 2009 at 6:41 am
When a suggestion was recently...
October 2, 2009 at 3:45 am
Phil Factor (10/1/2009)
If you're building a vehicle for human space flight or a nuclear reactor, the first choice is more likely to yield fewer dead astronauts and giant holes...
October 2, 2009 at 3:40 am
Some businesses at least have legal bounds on their information systems, such that software development either in a hurry or by non-specialists can get you into trouble. For instance...
October 1, 2009 at 9:13 am
So they know the user name to attack is "sa". Big deal. If God wanted to make your life harder and he gave the first two letters of...
September 18, 2009 at 9:22 am
I suppose you could pass the database name as another parameter. I'm not sure what happens with a temporary stored procedure that looks in local-database objects if you try...
September 18, 2009 at 4:41 am
Peter E. Kierstead (9/17/2009)We use extended attributes to track things of interest to us like deprecation and TTL (time to live) on SQL objects...
Peter E. Kierstead (9/17/2009)
So that's what extended attributes are for,...
September 18, 2009 at 4:27 am
I need to read this article carefully, but my immediate reaction is that the indexes that aren't used or don't even exist are the ones that should be considered for...
September 17, 2009 at 9:42 am
I agree with the comment that before or during your migration is NOT the time to look for stuff that appears to be redundant and deletable, because your migration will...
September 17, 2009 at 9:36 am
They will give you a key
To a noisy large room
Full of stuff that you'll see
In a "Dilbert" cartoon.
September 17, 2009 at 9:15 am
Several of the interesting articles in SQLServerCentral.com are of the form "Here is the stored procedure / script / business process that I use to..." Some of them are...
September 16, 2009 at 10:14 am