Viewing 15 posts - 39,391 through 39,405 (of 49,571 total)
Udfs have an unpleasnat tendency to perform rather poorly. One reason being that they run once for each row of the resultset so if you have 50000 customers, that function...
April 30, 2009 at 12:19 pm
RBarryYoung (4/30/2009)
Hmm, depending on the duplicates density, this might be faster:
Better on IOs, worse on time (at least on my PC)
SQL Server parse and compile time:
CPU...
April 30, 2009 at 11:44 am
RBarryYoung (4/30/2009)
Steve Jones - Editor (4/30/2009)
Anyone got a better performing solution than Gail?Heh. Now you know we'll need to see the execution plan to better answer that. 😀
Use...
April 30, 2009 at 11:40 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic707543-150-1.aspx
April 30, 2009 at 10:53 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic707717-146-1.aspx
April 30, 2009 at 10:49 am
April 30, 2009 at 10:46 am
Steve Jones - Editor (4/30/2009)
Anyone want to write a nice set-based solution to update the dups with row_number?
Delegating work? 😉
CREATE TABLE Users (
UserID int identity primary key,
UserName varchar(40),
...
April 30, 2009 at 10:43 am
David Benoit (4/30/2009)
If you feel up to it save the execution plan out and post it up for others to look at.
Absolutely.
There are cases where the 2005/2008 optimiser comes...
April 30, 2009 at 10:42 am
Lynn Pettis (4/29/2009)
How many people, besides myself, here on The Thread saw the original theatrical release of Star Wars when it was first released?
Not me, at least I don't think...
April 30, 2009 at 2:55 am
What you need to restore there is to find the full backup that the diff you're using is based on. A diff is based on the last full backup that...
April 30, 2009 at 2:27 am
Connection timeout and command timeout are not the same thing.
Connection timeout is the amount of time that the app will wait to establish a connection. This can be set using...
April 30, 2009 at 2:25 am
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx
From that page:
The time in seconds to wait for the command to execute. The default is 30 seconds.
So if you don't specify a command timeout, it's set at 30 sec.
April 30, 2009 at 2:03 am
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
That's on a SQL connetion, not a rdp connection.
April 29, 2009 at 3:59 pm
Bruce W Cassidy (4/29/2009)
[font="Verdana"]International Star Wars day... "May the 4th be with you."[/font]
*groan*
Hmmm, we were discussing having another Starwars day.....
April 29, 2009 at 3:22 pm
The only isolation level that you can set at a database level is Read Committed Snapshot (the optimistic concurrency version of read committed). Other than that, isolation levels are set...
April 29, 2009 at 3:00 pm
Viewing 15 posts - 39,391 through 39,405 (of 49,571 total)