Viewing 15 posts - 21,511 through 21,525 (of 49,552 total)
Vertigo44 (12/29/2011)
Now, what I am wondering is that if I run checkDB with the repair_allow_data_loss option, how much data will I loose?
Anywhere between nothing and everything. Seriously, there's no way...
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 29, 2011 at 8:25 am
Err, you wouldn't. Why would you want to load them into a temp table?
I've used a table variable to show the concept, because I don't have your table, so I...
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 29, 2011 at 3:31 am
DECLARE @Tbl TABLE (
UserName VARCHAR(100) ,
DateTime DATETIME ,
Action VARCHAR(50)
)
INSERT INTO @Tbl ( UserName , DateTime , Action)
VALUES
('abc','2011/01/22 23:45','xyz'),
('abc','2011/01/23 10:00','pqr'),
('abc','2011/01/24 12:00','zxc'),
('abc','2011/01/24 13:00','fgh'),
('def','2011/01/24 15:44','gpr'),
('ghi','2011/01/24 16:00','klm'),
('abc','2011/01/25...
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 29, 2011 at 3:14 am
@ry@n (12/29/2011)
I just need to see how the data is getting stored in the form of B-Tree.
Maybe have a read through this series:
http://www.sqlservercentral.com/articles/Indexing/68439/
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 29, 2011 at 3:08 am
Bhuvnesh (12/29/2011)
Did i overlook something...
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 29, 2011 at 3:06 am
Nope, it makes no difference and it hasn't likely since SQL 6.5 or 7, whichever one introduced the cost-based optimiser.
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 28, 2011 at 3:21 pm
In short, to maybe clear things up a little.
If SQL has to take an X lock on a row, it does the following:
Take an IX lock on the table -...
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 28, 2011 at 3:02 pm
Rich Weissler (12/28/2011)
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 28, 2011 at 2:17 pm
Fraggle-805517 (12/28/2011)
I can and will to test it, but why? Wouldn't that essentially be the same as the Clustered Index except the columns are reversed?
Yes, except much...
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 28, 2011 at 12:41 pm
lkokeunda (12/28/2011)
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 28, 2011 at 11:52 am
That quote's correct. The certs are retired, anyone who has them can still claim them, they just can't be written any longer.
My official exam transcript from MS still lists my...
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 28, 2011 at 11:15 am
Could you try changing the index Test to a unique index on ContactId, ContactGroupId and see what the execution time (with and without parallelism) looks like?
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 28, 2011 at 10:41 am
GSquared (12/28/2011)
Without some sort of auditing mechanism in place, can you think of another way to get "who changed my data"?
No, and if it was a sysadmin, the log 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 28, 2011 at 10:38 am
GSquared (12/28/2011)
I think ApexSQL and Lumigent produce log parsers.
At around $1000 for a single license.
RedGate used to, but I don't think they do any more.
They have one for SQL 2000...
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 28, 2011 at 9:50 am
MyDoggieJessie (12/28/2011)
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 28, 2011 at 9:47 am
Viewing 15 posts - 21,511 through 21,525 (of 49,552 total)