Viewing 15 posts - 48,001 through 48,015 (of 49,552 total)
I can't speak from personal experience w.r.t the DTA, as I've never used it outside a class room. I prefer to tune by hand.
What I have noticed with it is...
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
December 19, 2007 at 8:05 am
Have you had a look at the queries that are running against that DB? It could be that they are performing sub-optimally, doing more IOs than necessary, resulting in high...
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
December 19, 2007 at 7:59 am
Not permitted. Not in 2000 or 2005 transactional replication
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
December 19, 2007 at 7:50 am
What problems are you having with the 90GB db?
If there's nothing else running on the server, set the max memory to around 2.75GB and min to 2 GB
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
December 19, 2007 at 3:47 am
p1naga (12/17/2007)
Thanks for your suggestion. The query is performing ok.
If its performing OK, then leave the index as it was. A massive, great covering index (especially in SQL 2000) may...
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
December 19, 2007 at 1:02 am
The guid should be in single quotes, but other than that, I can't see anything wrong. I also can't see a '575' where the error could be near.
Can you post...
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
December 19, 2007 at 12:56 am
Can you please post the schema of the temp table, and the table you're updating from, as well as some sample data for both and the desired output.
Thanks
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
December 19, 2007 at 12:51 am
You may even get a different number of rows inserted into the table in the second one. Union eliminates duplicate rows.
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
December 18, 2007 at 8:31 am
Please don't cross post. It fragments replies and wastes people's 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
December 18, 2007 at 6:11 am
Ananth (12/18/2007)
i need to select only the latest 2 invoices for that account so inv4 should not be retrieved.
In the sample data you gave it is one of the latest...
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
December 18, 2007 at 5:58 am
I don't have a handy copy of express to play with, but you should be able to configure the server's min and max memory settings from management studio express.
In 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
December 18, 2007 at 4:00 am
Floats are inaccurate data types. Numerics are precise.
From Books online
The float and real data types are known as approximate data types. The behavior of float and real follows the IEEE...
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
December 18, 2007 at 3:46 am
Since you're using SQL 2005, look up Pivot in Books Online. Does exactly what you want.
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
December 18, 2007 at 3:41 am
What defines which invoices are considered top for each account? Invoice daet? Amount? Number of items ordered?
Can you please post the schema of the tables involved, some sample data and...
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
December 18, 2007 at 3:33 am
Philip Horan (12/17/2007)
Back up Database (Full) / Shrink Database / Rebuild Index / Reorganize Index
Don't shrink your production databases. It's a waste of time and resources and 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
December 17, 2007 at 2:03 pm
Viewing 15 posts - 48,001 through 48,015 (of 49,552 total)