Viewing 15 posts - 51,406 through 51,420 (of 59,072 total)
Most people crab about the duplicate disk space while that happens. If you don't mind that, then yes, the method you spoke of will be faster.
The problem is, the...
March 31, 2008 at 5:40 am
chinni (3/30/2008)
they asked to use curser becoz it needs to check the records every time for the changes for every baselineobject...........
I don't understand... why do you think that requires a...
March 30, 2008 at 5:26 pm
10813 is in milliseconds... 10813330 is in microseconds... divide micoseconds by 1000 to get milliseconds.
March 30, 2008 at 5:22 pm
Anirban Paul (3/27/2008)
I am late to join this discussion. Did you explore this library http://msdn2.microsoft.com/en-us/library/ms177673.aspx
It is a mine for T-SQL statements. I think most of your queries should be...
March 30, 2008 at 5:11 pm
I've got news for you Cory... getting the Bachelor's degree didn't make those guys smarter about SQL Server nor did it get them their jobs. A well written resume...
March 30, 2008 at 9:57 am
Todd Engen (3/30/2008)
Both of those can be addressed by a CLR stored procedure.
No... not in this case... not when the CLR does what the OP requested which is to basically...
March 30, 2008 at 9:07 am
I'm not really trying to discourage anyone from getting a degree... but consider this...
Against my wishes, the company hired a guy who had a PHd in Mathematics as the...
March 29, 2008 at 11:24 pm
Before you even think of spending the 20 to 30 thousand dollars to get a Bachelor's degree...
Why do you feel like the "green guy"? Why do you feel...
March 29, 2008 at 11:08 pm
Why not just post the problem(s) and see what you can get for nothing on this forum? Maybe people will even bid for the "job". 😉
March 29, 2008 at 10:43 pm
Well said. I especially like the two rules because, if you substitute the word "RBAR" for "Cursor", I use them all the time in a slightly different manner...
I. ...
March 29, 2008 at 10:41 pm
... and, as we both noticed, it's been fun, too boot! Thanks, Matt.
March 29, 2008 at 10:37 pm
M Chabot (3/28/2008)
...but the task fails if someone adds a new database to the server and doesn’t make a full backup before the maintenance plan runs...
Hi Mike...
Not the answer that...
March 29, 2008 at 8:19 pm
mostar5 (3/29/2008)
Hi, I need help on one or possibly more SPs. Please email me at mostar5@yahoo.com.
How much are you paying for the private consultation you're asking for? 😉
March 29, 2008 at 8:06 pm
Viewing 15 posts - 51,406 through 51,420 (of 59,072 total)