Viewing 15 posts - 55,561 through 55,575 (of 59,067 total)
PLEASE! If you want help, post the offending query that gave you the error! ![]()
August 1, 2007 at 8:25 pm
Good lord, NO!!!!
Vamshi, I know you're kinda new at this, but holy mackeral this is bad! And, if you didn't write it,...
August 1, 2007 at 8:15 pm
Just an FYI...Don't forget the other difference... UNIQUE key allows 1 NULL as a value... Primary Key won't.
And, you can also build a PK without it being clustered, although there...
August 1, 2007 at 7:47 pm
Anthony... it's bad form on this forum to post the same question more than once... ticks people off. Go to your other thread and read what I posted.
August 1, 2007 at 7:31 pm
I believe it uses the TAB delimiter for Excel spreadsheets...
August 1, 2007 at 7:30 pm
We had several procs with such lineage... the problem was that the main routine (forgive me for calling it that) had the BEGIN TRANS in it making for a very...
August 1, 2007 at 7:27 pm
Heh... first, your not auditing changes, you auditing the insertion of new data. If you want to audit changed, then you need to make the triggier FOR UPDATE, instead.
I've seen...
August 1, 2007 at 7:10 pm
Use your sample table... I just created my own and posted so other folks could see what's going on.
If that's not what you meant, you need to explain to...
August 1, 2007 at 6:45 pm
Hell, I know that DC... I'm not the kind of person who will go for a 10 second run when the current run is only taking 30 seconds on a...
August 1, 2007 at 8:18 am
To continue the analogy...
You have a small leak in a pipe that you noticed and you call the plumber. He shows up in a well used but very clean truck. ...
August 1, 2007 at 8:14 am
Cool... someone actually does read these
Thanks for the nice feedback, SDM.
August 1, 2007 at 7:31 am
Alright... first, I hate "Adjacency Models"... they're relatively slow and I hate recalculating things every time I want to look something up. Second, product tables don't change that often so...
July 31, 2007 at 10:01 pm
The neat think about counting Pennies is that the Dollars take care of themselves
Add the following to the end of my script...
July 31, 2007 at 9:09 pm
Case in point... I'm sure they thought it was pragmatic to do so, at the time...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=386825
... their batch job jumped from 16-20 hours to more than 70... and they...
July 31, 2007 at 8:51 pm
Yes... they are articles... but you don't have to go far to find them. When you installed the client side of SQL Server, you should have also installed "Books Online". ...
July 31, 2007 at 8:43 pm
Viewing 15 posts - 55,561 through 55,575 (of 59,067 total)