Viewing 15 posts - 31 through 45 (of 85 total)
Jeff Moden (11/5/2008)
I'd be tempted to use the one that uses the fewest resources... but lemme ask... are you returning any output from the procs to the screen?
During my test...
November 6, 2008 at 8:09 am
I have 2 versions of a stored procedure with I/O and time statistics below. I used DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE before running these on my local computer.
The first one...
November 5, 2008 at 10:45 am
AnzioBake (11/4/2008)
I use a variation on that syntax but found that the performance issue depends a lot on the table sizes that the parameters are used against
Which variation on...
November 4, 2008 at 7:39 am
Is there a threshold for CPU/elapsed time and IO costs where two stored procedures are close enough to be considered "equivalent"? Especially with time-based measurements, multiple executions of the same...
November 3, 2008 at 11:33 am
GilaMonster (10/31/2008)
See today's headline article. (http://www.sqlservercentral.com/articles/64582/)What's acceptable data loss for that system? A full day?
Yes, I can lose up to a day for the databases in question. Some other DBA...
October 31, 2008 at 4:25 pm
1976 (10/31/2008)
I plan to use dynamic SQL to create the SQL statement and sp_executesql for execution.
If your parameters are optional, do not create dynamic sql, but construct WHERE clause this...
October 31, 2008 at 1:06 pm
Grant Fritchey (10/28/2008)
October 29, 2008 at 6:41 am
Thanks for the info. I'll make the suggestions that you posted.
Grant Fritchey (10/28/2008)
October 28, 2008 at 6:38 am
SQLBOT (10/17/2008)
model and msdb don't matter... master doesn't really either
Are there any advantages/disadvantages to moving them/leaving them alone? For example, do I gain/lose anything if SQL Server crashes and needs...
October 17, 2008 at 6:33 pm
I like EXCEPT when I need to do "compound" comparisons.
What do you mean by "compound" comparisons?
October 8, 2008 at 11:55 am
bhovious (10/8/2008)
Why would you want to change what you have, if it's working?
I'm looking to change it because the "non-simplified" query is running slower than desired. I'm trying to systematically...
October 8, 2008 at 9:50 am
Garadin (10/3/2008)
Select EmployeeID,
...
October 3, 2008 at 12:25 pm
jeremiah.peschka (10/3/2008)
Essentially, yes, your mileage may vary. It's best to evaluate how a query will perform using a UDF both as a standalone query, as a sproc, and under...
October 3, 2008 at 10:56 am
Matt Miller (10/3/2008)
October 3, 2008 at 10:23 am
PW (10/1/2008)
Any SQL like this:
October 1, 2008 at 10:18 am
Viewing 15 posts - 31 through 45 (of 85 total)