Reputation
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
7 32 68
Impact
~492k people reached

19h
reviewed Close How to archive DB2 data
19h
reviewed Close How many passes of a table are done with UNION ALL?
19h
comment Migrate existing SQL Server database file to smaller files
Add a new filegroup, with 'x' number of files, then migrate the existing data onto the new filegroup.
1d
comment Named Pipe Provider Error code 40
you need more detail in your question. Please add the sqlcmd command line you used, along with how you are connecting in SSMS. Something is clearly different about how you are specifying the server name, etc.
1d
reviewed Close Named Pipe Provider Error code 40
1d
reviewed Reviewed How to sort new data for display?
1d
comment How to sort new data for display?
This sounds like a software design problem, not a database problem.
1d
revised Selecting the average of the top percent of duration, grouped by minute
added 221 characters in body
1d
reviewed Leave Closed Demoting a MySQL Master to Slave
1d
revised Selecting the average of the top percent of duration, grouped by minute
added 269 characters in body
1d
revised Selecting the average of the top percent of duration, grouped by minute
added 269 characters in body
1d
answered Selecting the average of the top percent of duration, grouped by minute
1d
revised Selecting the average of the top percent of duration, grouped by minute
edited tags
1d
comment Selecting the average of the top percent of duration, grouped by minute
What do you mean by top 5%? That subquery has no ORDER BY clause which means the "top 5 percent" could be any 5% of the rows in the table.
1d
reviewed Reviewed Generating a sequence of values
1d
comment SQL Server Performance in VMWare when creating different drives from a single Datastore
I'm voting to close this question as off-topic because virtual machine configuration should be asked on ServerFault.com
1d
comment SQL Server Performance in VMWare when creating different drives from a single Datastore
if nothing else, doing that will give the guest OS multiple paths to the storage system, which might help. YMMV.
1d
reviewed Reject Running a complex query for every date in a range
1d
comment Is smallest to largest the rule of thumb in a multi-table JOIN?
You may want to capture the salient points from those other pages; link-only answers tend to get deleted here.
1d
comment Running a complex query for every date in a range
You may want to flush that answer out with some details, sample code, etc. As it is, this answer may get deleted since it is pretty vague.