Viewing 15 posts - 19,831 through 19,845 (of 49,552 total)
Doable without a cursor. Look up NTile.
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
March 11, 2012 at 5:43 pm
Wow, with all the converts and functions and case and the complete lack of useful indexes its a wonder this ever performs well...
Can you post the two execution plans 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
March 11, 2012 at 5:41 pm
My guess, you're running into this problem: http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/
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
March 11, 2012 at 4:13 pm
There's a log backup that was taken on the primary but not copied to the secondary. Probably from someone running an ad-hoc log backup or a second log backup job.
Find...
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
March 11, 2012 at 1:40 pm
I certainly hope not, it's not a replacement for 'regular' nonclustered indexes. I can just imagine the chaos if the missing indexes did suggest columnstore indexes and people added 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
March 11, 2012 at 1:37 pm
cmdQuickPoDetails__Get.Parameters("@ProjectID").Value = CInt(Session("ProjectID"))
Is the session variable getting set correctly for that user's login?
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
March 11, 2012 at 10:39 am
Operating system error 21 means "The device is not ready", so you have a drive that has a SQL data file on it that's disappeared.
You need to resolve 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
March 11, 2012 at 10:38 am
I wouldn't say 'more of read-only', it's completely read only, the index and the table that it's on. I can see uses in OLTP systems (especially historical data). It's being...
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
March 10, 2012 at 12:06 pm
Drop the clustered index (it's the dependant object that the error message referred to)
Alter the column to not null
Add a 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
March 10, 2012 at 10:23 am
In testing several people have. Yes, they can be.
Look up Joseph Sack's blog post on 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
March 10, 2012 at 10:21 am
Read up on FOR XML PATH, it's a way of concatenating rows. There's an article on the simple-talk site.
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
March 10, 2012 at 3:50 am
150 VLFs is not a huge amount. Still, if you want to get that number down, shrink the log to 0 then regrow to full size in a small number...
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
March 9, 2012 at 3:26 pm
There are lots better ways to concatenate with commas than you have there. Look around for the XML Path method. When you find that, consider keeping 2 copies 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
March 9, 2012 at 8:10 am
Post the code you have so far. Just want to see how you've done 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
March 9, 2012 at 7:02 am
Cannot be done. Databases cannot be downgraded.
Got nothing to do with compatibility level, that can be changed up and down as you like, however once the database is attached to...
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
March 9, 2012 at 5:42 am
Viewing 15 posts - 19,831 through 19,845 (of 49,552 total)