Viewing 15 posts - 17,206 through 17,220 (of 49,552 total)
Well... To start all changes are made in memory and not to disk, and the changes to the files on disk are done later (by a background process) at 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
August 13, 2012 at 3:59 am
lianvh (8/13/2012)
Gila,thank you for the e-mail . Unfortunately we have no budget to procure the book .
I assume you didn't bother to look at the link, because the e-book 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
August 13, 2012 at 3:04 am
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 13, 2012 at 2:15 am
You need a comma after the filename before the size. You've also not closed the quotes after the strings in several places (eg FILENAME = N'C:\Program Files\Microsoft SQL Sever\MSSQL10.MSSQLSERVER\MSSQL\DATA\SQL2008SBS_1.ndf SIZE...
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 13, 2012 at 2:12 am
Welcome to the 'everyone has an opinion and none of them agree' topic. 🙂
Firstly don't set it to 1, that's an old 'best practice' that's nothing of the sort.
Is 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
August 13, 2012 at 2:07 am
Why are you asking, and at what level of the engine are you interested in? (because the behaviour is interesting and complex when you get down to the deep internals)
At...
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 13, 2012 at 2:02 am
SQLSACT (8/12/2012)
GilaMonster (8/10/2012)
No. That's literally the number of pages that were allocated, middle or end. Tracking mid-index page splits (which are the harmful ones) is near-impossible until SQL 2012.
So 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
August 12, 2012 at 12:31 pm
For unicode you need to divide by 2, as each unicode character takes 2 bytes. That's why a nvarchar(25) takes a max of 50 bytes (as the section you quoted...
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 12, 2012 at 7:28 am
I would agree with you, you want the fastest possible restore if such a restore is necessary, that's a full backup (or at most a differential backup that cab then...
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 12, 2012 at 6:47 am
No need for union in SQL 2008, grouping sets will work fine.
Try this. Untested because I don't have your tables
GROUP BY GROUPING SETS(
(Mat), ()
)
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 12, 2012 at 3:17 am
Please don't post multiple threads for the same problem
http://www.sqlservercentral.com/Forums/FindPost1343762.aspx
http://www.sqlservercentral.com/Forums/FindPost1343776.aspx
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 12, 2012 at 2:59 am
No, not unless you're interested in hiring me.
p.s. Your caps lock appears to be stuck
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, 2012 at 5:08 am
Shrink is a logged operation and so growth of the log is expected.
You probably shouldn't be shrinking the DB anyway. That's something that should only be done after some...
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, 2012 at 5:08 am
Then you need to get more drive space. No miracle solutions, you need to either remove files you don't need or get extra space.
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, 2012 at 4:33 am
Please give more detail.
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, 2012 at 4:31 am
Viewing 15 posts - 17,206 through 17,220 (of 49,552 total)