Viewing 15 posts - 28,996 through 29,010 (of 49,552 total)
Sqlsavy (12/7/2010)
SQL server has stopped generating error log from this morning.
Why do you say that? What log entries are you expecting that aren't there? How are you checking 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
December 7, 2010 at 9:27 am
Mine.
Isn't it rude to ask age? 😉
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 7, 2010 at 9:25 am
Another phrasing problem with the question - the maximum size of an index is not 900 bytes. The maximum size of the key columns is 900 bytes. The index row...
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 7, 2010 at 9:24 am
Birthday.
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 7, 2010 at 9:19 am
steven.malone (12/7/2010)
A little experimentation shows that most of the results that look like "false positives" can be explained by money.
The majority of the ones that won't convert to money...
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 7, 2010 at 9:18 am
The sys.databases view is new on SQL 2005 and hence it won';t work. There may have been changes to the MSDB tables as well.
Look up sysdatabases and DATABASEPROPERTYEX() for 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
December 7, 2010 at 5:51 am
No time like the present to learn.
http://www.google.com/search?q=%22SQL+Server%22+%22Insert+Trigger%22
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 7, 2010 at 5:50 am
I answer questions that I know the answers to and have time to answer. If I haven't answered a question it means either I don't have an answer or 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 7, 2010 at 5:46 am
A deadlock is a very specific condition. It's when two (or more) processes are in a state where each is waiting for resources the other has locked. It's a state...
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 7, 2010 at 5:45 am
Query sys.allocation_units and sys.data_spaces, identify the affected indexes and create ... with drop existing on different 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
December 7, 2010 at 5:01 am
Then all tables in that filegroup would have been striped across all files.
Shrinkfile with the Emptyfile option. Make sure there's enough space in the other files.
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 7, 2010 at 4:11 am
Is each file in its own filegroup, or are they all in one filegroup, or something in between?
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 7, 2010 at 4:03 am
For an individual query - SET Statistics IO on
Won't tell you writes. You'll need profiler for that, and those are logical writes (to memory)
For the DB as a while, sys.dm_io_virtual_file_stats.
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 7, 2010 at 3:58 am
Are you certain it's a deadlock not just a long-lasting blocking condition?
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 7, 2010 at 3:35 am
Define 'not working'
No intellisense at all? Not showing correct objects?
Absolutely sure it's not a 2005 instance you're connected 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
December 7, 2010 at 3:25 am
Viewing 15 posts - 28,996 through 29,010 (of 49,552 total)