27,529 reputation
23585
bio website rusanu.com/articles
location Seattle, WA
age 41
visits member for 3 years, 2 months
seen 6 hours ago

Apr
11
answered Create a certificate with a private key
Apr
11
comment Server permissions of an activation stored procedure of a Server Broker queue
@VansFannel please ask that as a standalone question
Apr
10
answered SQL Server 2012 Compatibility
Apr
7
comment Detecting changes in a SQL Server table
It is not a DMV designed for change tracking. Is very reliable for the intended purpose, which is performance tuning.
Apr
7
answered Detecting changes in a SQL Server table
Apr
3
comment A little clarification on how 'LIMIT' works
EXPLAIN SELECT * FROM <table> LIMIT 10 and post it here...
Apr
3
comment Why does sp_rename not affect the output of sp_helptext?
It's easy to see why, the captured input that created the module would have to be updated to change the definition. There are many dragons under that bridge, the task is significantly more complex than a string replace. And the result would be a lie.
Apr
2
comment Slow insert - 300+ Million Records
You have a performance problem and so analyze it like a performance problem: measure. Collect wait stats, performance counters, identity the bottleneck. Read How to analyse SQL Server performance
Apr
1
answered Differential databases (not backups)
Apr
1
comment Is it impossible to store 2^266 records on a database of some kind?
Isn't the logic circular? Wouldn't the 'custom database' be the resource they need, therefore not have yet?
Apr
1
answered Is it impossible to store 2^266 records on a database of some kind?
Mar
27
awarded  Revival
Mar
26
answered Reset SQL Server sa password
Mar
26
revised What are the risks of copying MDF/LDF files without detaching the DB first?
added 645 characters in body
Mar
26
comment What are the risks of copying MDF/LDF files without detaching the DB first?
Overwrite is a different story. Definitely not advised.
Mar
26
answered What are the risks of copying MDF/LDF files without detaching the DB first?
Mar
25
comment sqlsrvr.exe is not using all memory
Or the KB970070 which I linked that states "Make sure that the service account for SQL Server has the Lock Pages in Memory privilege enabled. You do not have to set these permissions if the SQL Server Service Account is the LOCAL SYSTEM account."...
Mar
25
comment sqlsrvr.exe is not using all memory
Read this blog post first which gives details on the algorithm in the engine for enabling AWE or for enabling “Locked Pages” and links to Do I have to assign the Lock Pages in Memory privilege for Local System?
Mar
25
comment sqlsrvr.exe is not using all memory
LPIM is a privilege that is already granted to certain accounts (eg. Local System). If the engine prints that in the errorlog, it means it successfully enabled the privilege. I must trust the engine message more than anything you say, sry. If LPIM is enabled, the engine will use AWE methods to allocate memory that the Task Manager does not report. For a correct view, just look at the SQL Server's own counters, as I suggested.
Mar
25
comment sqlsrvr.exe is not using all memory
Thanks Phillip, you just made my day, I literally burst into laugh.