Viewing 15 posts - 3,871 through 3,885 (of 5,685 total)
Okay, I found the problem... the error message just was never actually showing up in my output for some reason until I created a much more simplified version of the...
February 28, 2011 at 4:54 pm
You need to think of this in steps. First you need to find the first order in your system for each customer. This involves a MIN() and a...
February 28, 2011 at 4:34 pm
My personal opinion, when I find out about an ad-hoc instance of SQL server out there, is to attempt to find the owner(s), and discuss with them bringing them onto...
February 28, 2011 at 3:47 pm
GSquared (2/28/2011)
What happens if, instead of a message box, you log the message to a file or table?
I currently have logging in the SSIS package shipped to a table, it...
February 28, 2011 at 3:27 pm
When it comes to telecommuting, I'm an odd duck. I'm almost always an hourly consultant, and just about every employer wants chair warming to be part of the position....
February 28, 2011 at 1:23 pm
Jill-771690 (2/28/2011)
February 28, 2011 at 1:12 pm
Hey Jeff, your mailbox is full again. I didn't want to keep cluttering up the newbie's thread regarding unioning and the like, he's got enough confusion going on, but...
February 28, 2011 at 1:08 pm
Some days I think I know exactly how that dog is feeling at that moment...
February 28, 2011 at 12:58 pm
Amit, not really. You're basically forcing an update to every row in the table.
You can do some things that will help with availability, like making a copy...
February 27, 2011 at 9:48 pm
I'll second all the emotions about becoming a master and throw another bone in the mix. Po and Yoda were Old, with a capital O. I wanna do...
February 27, 2011 at 9:36 pm
Sorry for the delay, I was fiddling with the code you provided Jeff, trying to see what I'd not been paying attention to. I've known about a partitioned view,...
February 27, 2011 at 9:28 pm
Jeff Moden (2/27/2011)
February 27, 2011 at 6:12 pm
Jeff Moden (2/27/2011)
February 27, 2011 at 2:30 pm
aa.nichol (2/25/2011)
I did not have the room...
February 25, 2011 at 11:10 am
TheSQLGuru (2/25/2011)
And what is your preference when you notice that an index gets fragmented from 0% to say 90% after 24hrs? Do you reorganize it on a daily basis or...
February 25, 2011 at 11:09 am
Viewing 15 posts - 3,871 through 3,885 (of 5,685 total)