Reputation
928
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 12
Newest
 Yearling
Impact
~88k people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
Jul
1
answered How to reduce database log file size frequently?
May
11
comment Large Transaction Backup
Are you saying that there's a chunk of time during which you aren't running t-log backups? If so, my first suggestion would be to put that on a regular schedule that runs all the time.
May
7
comment How long does the final phase of an online index creation take?
I don't know for sure, but I think you answered your own question. That is, it'll take the amount of time that it takes to acquire the proper locks and reconcile any changes that happen in that amount of time.
Mar
11
comment How do I turn off ALTER DATABASE script output in VS 2012?
FYI - In SSDT, these seem to be in the Project Properties → Debug tab.
Jan
10
awarded  Yearling
Jan
2
answered At What Point Should I Split or Partition a Very Large but Simple Table
Dec
12
comment Is it normal that occasionally Page Life Expectancy drops to 0 and queries start giving timeouts in SQL Server?
This sounds entirely plausible. To corroborate, take a look at the Total Memory and Target Memory perfmon counters for your instance. If Target is higher than Total, SQL Server would like to have more but cannot get more. Also, worrying about performance characteristics on your laptop is somewhat of a fool's errand. Insofar as (in my opinion) your laptop is the place to prove that the functionality is correct, and an actual server is where you prove that it performs well.
Dec
12
comment How can you tell if a SQL Server instance max'ed out bottleneck is CPU or Memory?
A method of determining what the problem is is to look at what the query is waiting on. You can get a point-in-time view of this from sys.dm_os_waiting_tasks and sys.dm_exec_requests. Once you know what it's waiting on, you can either try to reduce your query's need for that resource or increase the amount of it. But without knowing what it's waiting on, saying that adding CPU or memory will help is just a guess.
Nov
21
awarded  Popular Question
Oct
31
answered A query that lists all mapped users for a given login
Sep
24
awarded  Autobiographer
Sep
10
comment Database Properties Error - sys.spt_values missing but dbo.spt_values works?
On a lark, have you tried connecting over the DAC?
Sep
1
awarded  Popular Question
Aug
19
comment Troubleshoot of WRITELOG on new machine running very slow?
From your description, it seems like these are the exact same operations just on different servers. Is that accurate? That is, there's not a change in anything like the batch size for your select into or how many tables are being created in one transaction? How about the recovery model of each db?
Jun
6
awarded  Notable Question
Jun
4
answered How to make snapshot for new tables only
May
28
comment SQL Server Deadlock - Two SELECT Exclusive Locks on Exact Same Index and Key
Is it possible that they were both waiting to escalate the lock from row -> page or page -> table? If so, the other select would prevent that from happening. Also, what's the transaction isolation level of each process?
May
2
answered Backup and Restore of Development
May
2
answered Mirroring between two Ms-sql servers for Migrating server from one Datacenter to other Datacenter
May
1
comment SQL Server 2012 Simple Recovery Model with LOG_BACKUP log_reuse_wait_desc
This is KB 2830400 (support.microsoft.com/kb/2830400) and is fixed in SP1 CU4 or RTM CU7. Just in case CU5 was too much.