SQL Server burns 100% of a single CPU core for a *very* long time when starting up a database with 64K filegroups and files. It does almost no IO, it is just burning CPU. This is unexpected because st…
Created on 2/3/2013 (updated 7 weeks ago) | 1 validation | 0 workarounds | 6 comments | feedback id: 778420
|
|
|
Closed
as Won't Fix
|
|
According to http://msdn.microsoft.com/en-us/library/ms188767.aspx a shutdown via the Service Control Manager does perform a checkpoint. This is very important behavior that ensures a quick service st…
Created on 1/13/2013 (updated 9 weeks ago) | 2 validations | 0 workarounds | 3 comments | feedback id: 776427
|
|
|
Resolved
as By Design
|
|
Repro:
- create a table
- create statistics on it
- go into the table designer and do something that requires it to rebuild the table (reorder columns for example)
- observe that the generated script …
Created on 9/14/2012 (updated 17 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 762740
|
|
|
Closed
as Won't Fix
|
|
SQL 2012 QE 3 installer has a button called "Next" in the "Check files in use step". Clicking it starts the installation. It takes SQL Server offline.
I repeat: A button called "next" takes SQL Serve…
Created on 8/31/2012 (updated 4 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 760702
|
|
- Open a new query window in SSMS and connect to a SQl Server
- Enable "Include Client Statistics"
- Execute "SELECT NULL"
- Observe that the client statistics where sent correctly
- Disconnect
- Conn…
Created on 7/8/2012 (updated 5 weeks ago) | 2 validations | 1 workaround | 6 comments | feedback id: 752809
|
|
Repo:
- Open SSMS and connect a new query window to a SQL Server
- Restart the SQL Server
- Execute any query ("SELECT NULL")
- Observe the following message:
Msg 233, Level 20, State 0, Line 0
A tr…
Created on 7/8/2012 (updated 6 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 752808
|
|
|
Closed
as Duplicate
|
|
SQL Server Management Studio disconnects all session when the computer goes to sleep or hibernation. For localhost connections this is not necessary: they would survive a sleep/awake cycle.
The probl…
Created on 5/12/2012 (updated 29 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 741843
|
|
|
Closed
as By Design
|
|
dm_db_database_page_allocations is a great new DMV in Denali to look at page allocations. Unfortunately, the implementation does exactly 4 times as much IO as needed.
Run this query on a big database…
Created on 5/12/2012 (updated 11 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 741821
|
|
|
Closed
as Won't Fix
|
|
1. Connect to some SQL Server with SSMS
2. Open "New Query". Execute some query to validate the connection
3. restart the remote SQL Server in order to interrupt the connection
4. Try to execute some …
Created on 10/2/2011 (updated 79 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 692648
|
|
|
Closed
as Won't Fix
|
|
1. Create a table with a BIT column
2. Create a filtered index on this BIT column ("ColumnName = 0")
3. Depending on how you query this column, sometimes the index is being ignored incorrectly. If you…
Created on 9/24/2011 (updated 3 weeks ago) | 3 validations | 0 workarounds | 1 comment | feedback id: 690623
|
|