Reputation
3,950
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 8 28
Newest
 Revival
Impact
~397k people reached

1d
comment DBCC Check DB issue
Do you only have 1 TempDB physical file and can you backup/erase wait_stats during the checkdb process?
2d
answered Install Express/Standard side-by-side
2d
comment Install Express/Standard side-by-side
No problem at all, I was just curious if there was a specific reason. It's pretty dang low risk but was just considering all the options. Good luck!
2d
comment Install Express/Standard side-by-side
Is there a really good reason you do want to use a shared root directory? From my experience on SQL 2000 and 2005 it sometimes wasn't the best option when it came to certain bugs. Having them separate would make it less likely that a change/patch in one might accidentally affect the other, in my opinion.
2d
reviewed Edit Sort operation SQL Server 2012
2d
revised Sort operation SQL Server 2012
Added table definition posted in comments and edited
2d
comment SQL Server 2014 - Disabled All Admin Users
Check out answer for alternative to single user mode if you're still having a hard time with it
2d
comment How to Replicate data between a hosted database and a local database
Any way we can put something in front of your app prior to the database, such as application level firewall/reverse proxy?
2d
comment Sudden Mongodb high connections/queues, db stops responding
I'm having a hard time figuring this one out. Could you let us know what mongoDB version you're running, your hardware specs (CPU and RAM), your collection sizes, and what drivers you're using to connect to MongoDB? Also,w hat happens if you use just KILL instead of sigkill?
Feb
9
revised what is running VSS on my server
edited tags
Feb
9
answered Can not connect to HP\SQLEXPRESS
Feb
8
reviewed Edit create table in a different schema
Feb
8
revised create table in a different schema
replied to comments
Feb
8
comment Partitioning a table on a column in another table
Are you open to a Partition Aligned Indexed View? You will eat up more memory, more diskIO, but your reads will be very fast and with proper partition elimination, you'd theoretically use less memory.
Feb
8
reviewed Approve Every “INSERT” query check a combination of column's records
Feb
5
comment Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command
@srutzky just a quick point from your last comment, I saved considerable time breaking up my backups into multiple files going to the same volume. I just wanted to share that with you just in case it wasn't something you tried yet. If your 206 DBs run a backup in parallel across multiple DBs though you might not get the multi-threading benefits.
Jan
29
comment Sudden Mongodb high connections/queues, db stops responding
Are you running both mySql and MongoDB on the same host?
Jan
26
reviewed Edit How to improve this union to ensure consistent results?
Jan
26
revised How to improve this union to ensure consistent results?
add postgres,query tag
Jan
26
comment Get sum of amount monthly
please use: translate.google.com