Reputation
928
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 13
Impact
~95k people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
Aug
13
awarded  Popular Question
Aug
3
comment Replication with fail over cluster in SQL Server 2014
@pradeepkumaralugurthi: No. In a failover cluster instance (FCI), there is only one instance of the SQL server which can be live on one (and only one) of the machines in the Windows cluster at a time.
Aug
1
comment There is no option of audit in security for SQL Server 2014 .How to enable audit option for same?
Audit is an Enterprise-only feature. What edition of SQL Server are you running?
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?