Viewing 15 posts - 24,631 through 24,645 (of 49,552 total)
This is a fantastic discussion, slightly old but not seriously so:
http://runasradio.com/default.aspx?showNum=81 (30 min or so podcast)
Many of the metrics can be trusted and used, not in terms of hard thresholds,...
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
July 28, 2011 at 4:38 am
Ninja's_RGR'us (7/27/2011)
mtillman-921105 (7/27/2011)
Actually, bacteria gas. (CO2) Delightful, isn't it? And I like swiss cheese.So I guess Baby Swiss uses mini-bacteria?
Anti-matter.
For cheese that packs a real *boom*
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
July 27, 2011 at 2:26 pm
No, and don't worry about 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
July 27, 2011 at 1:59 pm
Jim Murphy (7/27/2011)
Useless post just to make 500.I hate when people do this.
I'd do one, but it appears I'm off by more than one this time...
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
July 27, 2011 at 12:31 pm
Glad to hear
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
July 27, 2011 at 12:30 pm
Gavin Heer (7/27/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
July 27, 2011 at 11:52 am
Brandie Tarvin (7/27/2011)
I wonder if they have super-secret permissions levels that are higher than SysAdmin which gives objects access to their hidden tables during the course of normal processing.
Typically they...
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
July 27, 2011 at 11:47 am
Shut down SQL, copy the data and log files of the system resource, start SQL, attach them as a user database and play. On a dev/test server.
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
July 27, 2011 at 11:29 am
Turning that into something that's actually readable....
RESTORE DATABASE [db1]
FROM VIRTUAL_DEVICE='VDI_D8B0897D-3BBC-412F-B7F3-AF854B8906C6_0',
VIRTUAL_DEVICE='VDI_D8B0897D-3BBC-412F-B7F3-AF854B8906C6_1',
VIRTUAL_DEVICE='VDI_D8B0897D-3BBC-412F-B7F3-AF854B8906C6_2'
WITH BLOCKSIZE=65536, MAXTRANSFERSIZE=1048576, BUFFERCOUNT=20, STATS = 10,
MOVE N'db1' TO N'P:\MSSQL.10\Data\db1.mdf',
MOVE N'db1_log' TO N'P:\MSSQL.10\Data\db1_log.ldf',
MOVE N'db1_Indexes'...
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
July 27, 2011 at 11:27 am
You can't edit the system tables (and you shouldn't even consider it)
What do you mean by 'stale'? Has TempDB been changed since the last server restart?
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
July 27, 2011 at 11:22 am
Full text indexes and fulltext predicates are very prone to poor estimation. They don't use the column statistics (can't, the statistics are for equality or range, not 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
July 27, 2011 at 10:37 am
Ratheesh.K.Nair (7/27/2011)
We restored the DB to different server and it created a duplicate file for one .ndf file.We tried our best but not able to delete that file.
Post your...
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
July 27, 2011 at 10:34 am
What about SAN logs? Raid array logs? Windows event logs?
Have they checked that the drivers/firmware is up to date?
Chkdsk alone is not sufficient. Something corrupted your database, that something was...
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
July 27, 2011 at 9:43 am
Huh?
Drop the corrupt database (after taking a tail-log backup and verifying that the backup you're using really is clean), restore a clean backup.
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
July 27, 2011 at 9:40 am
Yes. Windows logins get their SID (not GUIS) from Active Directory.
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
July 27, 2011 at 9:39 am
Viewing 15 posts - 24,631 through 24,645 (of 49,552 total)