Viewing 15 posts - 35,911 through 35,925 (of 49,552 total)
Traceflags change some piece of behaviour of the database engine. No idea what 8107 does, can't seem to find any info on it. Have asked some friends.
You'll probably find this...
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
November 11, 2009 at 12:35 pm
There's also one on Michelle's blog - http://www.sqlfool.com
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
November 11, 2009 at 12:25 pm
blambu56 (11/11/2009)
I create all my tables in Enterprise Manager. I dont use scripts for those thats probably why the one I posted is wrong.
A syntax check would have shown it...
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
November 11, 2009 at 12:19 pm
What's the error?
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
November 11, 2009 at 11:38 am
The queries that, when they are run, show wait times with the async network io wait type. Query sys.dm_exec_requests to get a snapshot of what's happening. Do that repeatedly at...
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
November 11, 2009 at 11:37 am
Ok, now I'm really confused. If you're doing sums later, surely you need all the rows? If not, which of the 'duplicate' rows do you want to keep and which...
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
November 11, 2009 at 11:34 am
John Colby (11/11/2009)
What does "narrow" mean in the "considerations for selecting the clustering key".
It refers to the width of the column, ie the number of bytes it takes....
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
November 11, 2009 at 11:09 am
There are two rows with ClientNumber, ClientAccNumber 6035BD,101422296. What determines which of the rows you want in the output?
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
November 11, 2009 at 11:06 am
Attach them. Look up CREATE DATABASE ... FOR ATTACH in Books Online. It's not always possible to attach the files, especially if the DB was no online or the database...
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
November 11, 2009 at 10:07 am
Look it up in Books Online. Far faster than waiting for someone to come along, see your question, look it up in books online and post the answer for you.
http://msdn.microsoft.com/en-us/library/ms188917(SQL.90).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
November 11, 2009 at 10:01 am
Is this a clustered SQL Server?
Are you creating the DB from management studio gui or from script? If script, paste it here please?
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
November 11, 2009 at 10:01 am
Charles Kincaid (11/11/2009)
Sadly we're still on SQL2000
Most every thing Gail said applies to 2000. I'm setting on a bunch of 2000 deployments and a load of 2005...
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
November 11, 2009 at 9:57 am
I keep on seeing this. Kinda an incomplete cleanup of the replication.
Create a new transactional replication publication.
run sp_repldone in that db. This will not affect the snapshot replication
Drop the publication.
Check...
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
November 11, 2009 at 9:52 am
daveFromIll (11/11/2009)
Thank you Gail. we will definitely look into Read Uncommited snapshot
Read Committed Snapshot Isolation Level.
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
November 11, 2009 at 9:13 am
Does the directory N:\Backups\Userdatabases\Database\ exist?
Do the SQL agent and SQL Server service accounts have permission to that directory?
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
November 11, 2009 at 9:11 am
Viewing 15 posts - 35,911 through 35,925 (of 49,552 total)