Viewing 15 posts - 20,566 through 20,580 (of 49,552 total)
Well there's your problem right there.
You need to analyse and add primary keys. My guess would be MailMergeFile should be on MailMergeID and MailMergeWorkItem on MailMergeID and WorkItemID, but that's...
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
February 6, 2012 at 6:26 am
Indexes on those tables? Primary key?
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
February 6, 2012 at 6:06 am
Ow, that's probably the slowest of all of the options that the article discussed, and the article even stated:
Because they are generally resource intensive, procedural and inefficient, one should strive...
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
February 6, 2012 at 5:46 am
The installing of SQL on a standalone server is the easy part. You'll need to restore backups of all the databases, configure all logins and server-level permissions, change the 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
February 6, 2012 at 5:34 am
Please post the code for the procedure UpdateMailMergeStatus and the definition of MailMergeFile with all indexes
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
February 6, 2012 at 5:30 am
Did you read the article? There's lots of ways listed and covered in that and lots of sample code. CTE is far from a requirement.
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
February 6, 2012 at 5:29 am
bram.krol (2/5/2012)
Disk latency (read) on the fast SAN is an average 7 ms, on the slower SAN average 32 ms.
Yup, definitely a disk latency problem. Where and why is a...
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
February 6, 2012 at 5:18 am
Lots of ways.
http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
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
February 6, 2012 at 4:18 am
All 5 million, not keeping any rows at all?
If so:
TRUNCATE TABLE <table name>
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
February 6, 2012 at 4:13 am
johnitech.itech (2/6/2012)
ok check below link plshttp://stackoverflow.com/questions/71022/sql-max-of-multiple-columns
What exactly does the link have to do with the question? The question is about restricting query costs, the link is about finding the max...
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
February 6, 2012 at 4:13 am
No, take offline and bring online (the DB) should be enough.
Question is, why are the permissions wrong? NTFS doesn't just randomly change folder permissions, so something's happened or someone's been...
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
February 6, 2012 at 4:10 am
jcb (2/6/2012)
Gail solutions is the more elegant (as usual) but works only in MSSQL Server 2008.
Which, since this is posted in the SQL 2008 forums is probably not a problem.
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
February 6, 2012 at 4:09 am
johnitech.itech (2/6/2012)
ok check below linkshttp://www.databasejournal.com/features/mssql/article.php/3618061/MS-SQL-Joins---Part-1.htm
What exactly do those have to do with a key lookup?
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
February 6, 2012 at 4:08 am
rajg (2/6/2012)
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
February 6, 2012 at 3:31 am
Given the distribution of answers, I'm considering a followup question - "does recovery model ever affect the ability to rollback transactions?" because it appears way too many people don't understand...
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
February 6, 2012 at 3:29 am
Viewing 15 posts - 20,566 through 20,580 (of 49,552 total)