Reputation
34,943
Next tag badge:
459/400 score
78/80 answers
Badges
2 50 107
Newest
 Caucus
Impact
~1.4m people reached

2d
answered Whay does the SQL Server Service account has the “”Impersonate a client after authentication" Right?
2d
answered How to create test environment for lost transactions
Aug
26
comment How to identify when to change Indexes
Index advisor has a +24 hours cycle until it gives a recommendation. If you mention 'some query' you should also link it. Is probably querying sys.dm_db_missing_indexes_xx
Aug
26
comment What collation to use for Ukraine?
Missing Ukrainian collation on MSDN seems to be documentation issue. SELECT * FROM sys.fn_helpcollations() sure shows it present.
Aug
26
answered How to identify when to change Indexes
Aug
18
comment Speed of Split Database vs ODBC with SQL Server vs ODBC with Azure Cloud
Is this normal? No. You have severe SQL Server performance issues, certainly you are missing the required indexes in the database. Read How to analyse SQL Server performance
Aug
12
comment SQL Server 2012 memory issue
How to analyse SQL Server performance
Aug
9
comment Remove mixed extents in SQL Server
Again, what si the actual problem you're trying to solve?
Aug
9
comment Remove mixed extents in SQL Server
What is the actual problem you're trying to solve?
Aug
5
comment How to find SQL Server database is in use or not?
This is wrong on two accounts: 1) sessions setting DB as context (which is the intent of the query) does not equal to DB use since a session with context in DB1 can reference (hence use) DB2 via 3 part names and 2) it uses deprecated views, at least use sys.dm_exec_sessions
Aug
4
answered How to find SQL Server database is in use or not?
Aug
3
awarded  Caucus
Aug
3
awarded  Constituent
Aug
3
comment How to tune a stored procedure that is fast on test data but slow in production
How to analyse SQL Server performance
Jul
31
comment What happens when the mirroring server goes offline (for a short while)?
That part is true, but with the addendum that it only applies to the "synchronized" state.
Jul
31
comment What happens when the mirroring server goes offline (for a short while)?
@Zapnologica If the mirror could not go offline in sync mode then it would be called "High unavailability mode", as the mirror could bring the primary offline! The mirror can absolutely go offline, then the mirroring on the primary continues in "running exposed" mode: If the mirror server instance goes down, the principal server instance is unaffected and runs exposed (that is without mirroring the data).
Jul
25
comment Multi-threaded inserts vs serial
This is the wrong question to ask. You have a performance problem, analyze it, find the bottleneck and address it. How to analyse SQL Server performance
Jul
24
answered SQL Server : If a query is cancelled, where to get data on it?
Jul
23
comment SQL server database performance issue
How to analyse SQL Server performance
Jul
23
comment FIPS 140-2 Compliance
Strictly speaking does not to be separate 'hardware', it can be a separate VM. But yes, once the OS enables FIPS compliance then all instances on that host will run in compliance mode.