meta user
network profile
| bio | website | |
|---|---|---|
| location | New York, NY | |
| age | 51 | |
| visits | member for | 2 years, 4 months |
| seen | May 16 at 2:31 | |
| stats | profile views | 45 |
|
Mar 29 |
comment |
SQL Server 2005 Unexpected Disk Usage during Backups Sounds like a snapshot file or a temp file from 3rd party backup; is it a normal sql backup? Filemon should definitely have something jump out. |
|
Mar 26 |
answered | why would command text not execute at all? |
|
Mar 26 |
answered | Stored Procedures under Source Control, best practice |
|
Jan 22 |
awarded | Yearling |
|
Nov 30 |
comment |
How do I determine what MDF files are in use I think one danger with this technique is if auto-close is enabled on any databases, you could probably delete an mdf that is still attached. Haven't tried it though. |
|
Oct 27 |
answered | overhead for INSERTS using change tracking and/or change data capture (CDC) |
|
Oct 27 |
answered | Execution plan results for sp_executesql suggests adding missing index for already existing index |
|
Oct 27 |
revised |
How to test mirroring with a single Microsoft SQL Server license? added 439 characters in body |
|
Oct 27 |
answered | How to test mirroring with a single Microsoft SQL Server license? |
|
Jul 25 |
comment |
SQL Server 2012 Data Warehousing Overall Flow Read The Microsoft Data Warehouse Toolkit by Joy Mundy, and also the Kimball books, they give very good guidance. |
|
Jul 23 |
comment |
Always being logged in as SA and not Windows account Is it because you are in the sysadmin group on your machine but not on the server? You could remove your account from sysadmin locally, but you have to be care to make sure you have another account to administer the server with. |
|
Jul 21 |
comment |
Always being logged in as SA and not Windows account sounds like the default schema is not set for the account; run "select default_schema_name , type_desc , name , create_date from sys.database_principals " on both and check your account. |
|
Jul 20 |
comment |
Always being logged in as SA and not Windows account Are you using Management Studio to connect? If so, check the properties on the connection. Or create a new connection in Registered Servers and specifiy Windows Authentication. |
|
Jul 2 |
answered | Optimising a query using hint locks |
|
Jun 23 |
revised |
Why CDC records nothing while being enabled? edited tags |
|
Jun 23 |
revised |
Why CDC records nothing while being enabled? edited tags |
|
Jun 23 |
answered | Why CDC records nothing while being enabled? |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
May 31 |
comment |
Defragmenting SQL Server data and log files live with MoveFile API I'd be asking how SQL server disks got so fragmented; proper planning and space management makes fragmentation a non-issue. |
