Reputation
2,018
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
6 15
Newest
 Enlightened
Impact
~117k people reached

Jan
7
awarded  Enlightened
Jan
7
awarded  Nice Answer
Sep
13
awarded  Yearling
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)
Feb
18
answered Does DBCC TRACEON() invalidate cached execution plans?
Sep
24
awarded  Autobiographer
Sep
13
awarded  Yearling
Oct
5
awarded  Revival
Oct
4
answered Restore of logfiles in SQL Server
Sep
13
awarded  Yearling
Jun
3
revised How large will the Transaction Log backup be?
improved answer with an option I'd stupidly forgotten to add.
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
revised Msg 5145: Autogrow of database log file took 1010871 milliseconds
bulleted options to make them stand out more
May
31
answered How large will the Transaction Log backup be?
May
31
answered Msg 5145: Autogrow of database log file took 1010871 milliseconds
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
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.