Viewing 15 posts - 16,681 through 16,695 (of 49,552 total)
If you run repair, you will lose data, hard to tell what (I can't remember how CheckDB handles cases where a page is allocated to two tables). It may result...
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
September 11, 2012 at 4:16 pm
HooRoo (9/11/2012)
My colleague is under the impression that A is simply translated into B by the database anyway,so insists that B is preferable.
He's correct that A is translated into...
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
September 11, 2012 at 4:09 pm
Decimal 4, 4 allows for 4 digits, all 4 to the right of the decimal. So it stores values between 0 and 0.9999 (on the positive side), but it cannot...
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
September 11, 2012 at 9:26 am
If you are creating an indexed view on Standard edition, any query (from anywhere at all) that you want to use the indexed view must have the NoExpand hint on...
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
September 11, 2012 at 7:56 am
A heap is a table that does not have a clustered index defined on 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
September 11, 2012 at 7:54 am
Don't understand the question.
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
September 11, 2012 at 7:41 am
nharris (9/10/2012)
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
September 11, 2012 at 7:39 am
mw112009 (9/11/2012)
I always thought a PRIMARY key is always a clustered index ( Right ? Wrong ? )
Nope. A PK is enforced by a clustered index if there is 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
September 11, 2012 at 7:36 am
The estimation in the error log can be on the low side. Expect at least as long as the operation took before you stopped it and restarted SQL.
btw, you didn't...
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
September 11, 2012 at 5:49 am
As I said, you cannot control what data goes onto what file when there are multiple files in a filegroup.
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
September 11, 2012 at 5:28 am
If there are two files in a filegroup, SQL spreads the data evenly across the two files, you cannot control which file in a filegroup gets what data.
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
September 11, 2012 at 4:33 am
Wait.
Recovery takes time. When you restarted SQL, the transaction hadn't finished rolling back, so now it has to finish rolling back before the DB can be brought online.
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
September 11, 2012 at 4:24 am
t.brown 89142 (9/11/2012)
Just noticed your name in the sig line - and that you're technical reviewer on the book!
Yup
and apologies - yours isn't a picture of Obi-Wan either 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
September 11, 2012 at 4:22 am
jitendra.padhiyar (9/11/2012)
the size of the normal page is 8 KB, what is be the size of LOB pages ?
8k. All pages without exception are 8k
Can one row be written(expand)...
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
September 11, 2012 at 4:21 am
jitendra.padhiyar (9/11/2012)
My question is what will happen when the length of the row is more than maximum capacity of sql server?
If the row is comprised of fixed-length data types, you'll...
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
September 11, 2012 at 4:14 am
Viewing 15 posts - 16,681 through 16,695 (of 49,552 total)