Viewing 15 posts - 39,376 through 39,390 (of 49,552 total)
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2009 at 10:49 am
http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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),
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2009 at 2:03 am
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
That's on a SQL connetion, not a rdp connection.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2009 at 3:00 pm
Asked and (partially) answered here
http://www.sqlservercentral.com/Forums/Topic707203-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2009 at 2:40 pm
If you don't do any changes at all, mark the databases as readonly and SQL will take no locks when querying it.
There's no other way to make read uncommitted the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2009 at 2:23 pm
Steve Jones - Editor (4/29/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2009 at 1:51 pm
What you're seeing is perfectly normal. A login that's a member of the sysadmin group does not automatically get a user created in each database, rather they are 'mapped' to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2009 at 10:12 am
Viewing 15 posts - 39,376 through 39,390 (of 49,552 total)