Viewing 15 posts - 31,306 through 31,320 (of 49,552 total)
Yes you can.
I would like to add a couple words of caution - by using that hint you're essentially telling the optimiser to mind its own business, that you...
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
August 11, 2010 at 8:05 am
How big is the index? How many pages in total?
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
August 11, 2010 at 7:57 am
Ray K (8/11/2010)
Sounds interesting. Any suggestions on where we Yanks can find it here in the States?
Interesting and awesome!
Have a try here - http://funkymunky.co.za/safood.html - several links for various...
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
August 11, 2010 at 7:47 am
Use it for what?
To view, if it's saved as a .sqlplan file, just open it in management studio.
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
August 11, 2010 at 7:26 am
Grant Fritchey (8/11/2010)
I think this is available in 2005, is set the system option "optimize for ad hoc workloads" to true.
2008 feature, along with the two options (access...
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
August 11, 2010 at 5:58 am
The T-SQL I posted above does exactly 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
August 11, 2010 at 5:22 am
Dumps are cheating. They are actual questions taken from the exam in violation of the rules around the exam. Using or asking for braindumps can result in your certifications 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
August 11, 2010 at 4:32 am
Restore onto a non-express instance, shrink the data file, backup then restore on SQLExpress. (I don't recommend shrinking the source database due to the side effects of shrink)
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
August 11, 2010 at 4:29 am
You still haven't answered by question on order. 1st, 2nd rows ordered by what? Grouped by what?
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
August 11, 2010 at 2:53 am
Before, ordered by what? What and how do you define that one row comes before another?
For the sample data that you posted, what should the end dates be?
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
August 11, 2010 at 2:41 am
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
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
August 11, 2010 at 2:27 am
While the backup file is only 900MB, the original database was larger than 4GB, and Express is limited to a 4 GB data file.
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
August 11, 2010 at 2:26 am
So for a row with a startdate of 2004-01-01, you want the end date to be 2003-12-31?
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
August 11, 2010 at 2:25 am
Ok, but what do you want to update the end date with? Where's the new values supposed to come from?
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
August 11, 2010 at 2:09 am
Please post the table's definition? (Create table)
What are you updating the column with?
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
August 11, 2010 at 1:46 am
Viewing 15 posts - 31,306 through 31,320 (of 49,552 total)