Viewing 15 posts - 10,531 through 10,545 (of 18,923 total)
I see you are getting more and more helpfull to those in need. Thanx for sharing all the usefull information.
December 18, 2006 at 1:08 pm
.. or they just didn't think it through. But I agree that this is a somewhat strange requirement.
December 18, 2006 at 1:07 pm
So what ?! just use microseconds instead of milliseconds in the results
.
December 18, 2006 at 1:05 pm
This seems to do it (didn't test it).
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1332
December 18, 2006 at 12:30 pm
I now remember why I don't have a set based version for this one... I just can't beat the loop into submission
. This...
December 18, 2006 at 12:25 pm
2 options come to mind at the moment :
1 - sp_updatestats
2 - Create a table variable with the key column(s) of the table.
Insert into @TV (KeyCol) Select KeyCol FROM...
December 18, 2006 at 12:07 pm
Yes the command parameter is a nvarchar, so you can pretty much do whatever you want. The difference lies with the fact that ? is a placeholder for the current...
December 18, 2006 at 11:52 am
Thanx for the tip. Is there any link you can provide with information on the low level performance tuning like this one?
December 18, 2006 at 11:47 am
It's good to be it's own boss
.
December 18, 2006 at 11:46 am
If it is forbidden in your environement, then just use a loop or cursor and build the dynamic sql string just like in the command. The results will be the...
December 18, 2006 at 10:55 am
I'm sure there is but the only thing I can find on short notice is in the index tab of the books online when you can scroll to functions and...
December 18, 2006 at 10:39 am
Surely you could find something close to that in books online but I have no clue of where to get you started looking for this!
December 18, 2006 at 10:18 am
Viewing 15 posts - 10,531 through 10,545 (of 18,923 total)