Reputation
1,893
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 14
Impact
~75k people reached

Mar
2
comment Update taking too long
What's the output from this query on your instance? select session_id, blocking_session_id, wait_type from sys.dm_exec_requests where session_id>51 This will let us know if your query is potentially blocked by another query, or what type of activity the query is waiting on (it might be IO, or Network, or something else)
May
31
comment How large will the Transaction Log backup be?
@TomTom - Unfortunately that's not the case. Paul Randal wrote a comprehensive blog post about this - sqlskills.com/blogs/paul/…
May
31
comment Autogrow of database1_log file in database database1 took 1010871 milliseconds
TomTom's suggestion of 8GB would be good if you weren't experiencing what appears to be problems with slow disk when allocation 5GB. So maybe try with 2GB? The other option as mentioned is to create your database with a 50GB transaction log. Then you'll only have to wait while it's created then, rather than while executing your query.
May
31
comment Copy a SQL Server database from one server to another on demand
How large is the database? If it's particularly big then backup/restore will be the most efficient way to do this.
May
31
comment Autogrow of database1_log file in database database1 took 1010871 milliseconds
How big are the data and log files? And what are the autogrowth settings?
May
30
comment How to set SQL Server index pages per fragment?
What are you using for a clustered key for the table? Is it a monotonically increasing value (like an INDENTITY) or is it random (eg; GUID or character string). If it's the latter you may be getting page splits due to data having to be inserted to an existing page.
May
17
comment sql server 2008 execution plan different on two production servers
Are the statistics on both servers the same and up to date? I if one of them has stale stats for a table/index that will throw a plan off.
May
17
comment Copy tables from a stand-by database
And do you want to move structure and data, or just the structure?
Mar
4
comment Efficiently retrieve big amount of data based on date range
Can you proved the create scripts for the table and it's indexes please. So we can see the data types and what you're currently doing.
Feb
12
comment Restore the latest backup on the database
Yes, it does make a difference as you don't need to scan the backup files. I've updated my answer with details about that scenario.
Feb
11
comment Restore the latest backup on the database
Will you be able to query the original server while doing the restore? Or is it in a completely seperate environment?
Feb
5
comment Change SQL Server 2008 name
what happens if you run the following DOS command: nslookup SERVER2
Feb
5
comment how to insert data from one table to another
I have edited an an extraneous column that I used for testing. Here's a SQLFiddle showing it working - sqlfiddle.com/#!2/ea8e8
Feb
4
comment how to insert data from one table to another
OK, I've edited my answer to incorporate your revisions, though please note that as the created column isn't defined anywhere I can't answer that section.
Feb
4
comment how to insert data from one table to another
What's the created column?
Feb
4
comment how to insert data from one table to another
BTW, I made a mistake in the previous note, and meant is SKU always the string 'prod-' with the id appended. If there's no relationship, then this query logically can't exist as there's no way to like a specific sku to a particular id.
Feb
4
comment how to insert data from one table to another
How are id and sku related? Is sku allways 'sku-'+id ?
Feb
4
comment Using data from other database to populate a new database
You have more columns in target than source, and they're also NOT NULL columns. Where are you getting the other values from? (This will affect the query you need to use).
Jan
17
comment How to identify the db orphan mdf and ldf files
good points. I'd forgotten to account for multiple instances.
Jan
16
comment Backup Only Database Schema Everynight
When you say 'schema only', are you meaning you only want to backup certain schemas. Or are you using schema to mean the db structure, and you want the create scripts for tables, indexes, etc?