Viewing 15 posts - 46,981 through 46,995 (of 49,552 total)
Is there overlap between the unioned queries, ie, will a row be returned by more than one of them?
If not, change the unions to union All.
Union forces a distinct...
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 7, 2008 at 1:37 pm
Apologies, this is more than a bit later...
How does this look?
There is some stuff left out, I don't know how you're doing the export of mailing, but the comments should...
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 7, 2008 at 1:33 pm
I'm pretty sure that info's in the database boot page, but I don't know where or how to interpret it.
The one person around here who will know is Paul Randal....
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 7, 2008 at 7:32 am
Could you please post some sample data and expected output. Also the index definitions would be useful
Looking at your query, the multiple subqueries are very likely the cause of 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 7, 2008 at 7:27 am
Congrats guys.
Keep up the good work
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 7, 2008 at 7:09 am
I've read some articles that say that truncate is not logged, hence cannot be rolled back. The truth is that truncate is a partially-logged operation.
The row 'deletions' are not...
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 7, 2008 at 12:26 am
First thing is to check through the query and make sure that it is written as optimally as possible (avoid triangular joins, subselects in the select clause, functions on columns...
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 7, 2008 at 12:21 am
Sequel. Just because it rolls off the tongue easier.
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 7, 2008 at 12:13 am
The SQL Engine, by default won't release memory. You can specify the min and max memory settings (if necessary) and SQL will manage its memory within those boundries. The only...
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 7, 2008 at 12:04 am
Any IBM DB2 linked servers by any chance?
As a possible other option, you can run linked servers out of process. Then they get their own memory spaces and won't hog...
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 6, 2008 at 11:59 pm
It's good practice to always specify the column names in an insert statement. I have modified my earlier post to reflect 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 6, 2008 at 11:57 pm
Are you using Snapshot isolation level?
Are you doing online index rebuilds?
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 6, 2008 at 11:55 pm
julia.nicholas (4/4/2008)
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 4, 2008 at 8:12 am
Could you explain more what you want please?
What are you trying to see?
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 4, 2008 at 6:09 am
Just bear in mind that the 'encryption' of views/stored procs is not unbreakable.
Took me under 5 min last time.
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 4, 2008 at 5:26 am
Viewing 15 posts - 46,981 through 46,995 (of 49,552 total)