Reputation
257
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 7
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 14 votes cast
Feb
19
revised How to efficiently create a new PRIMARY KEY CLUSTERED definition online
added 35 characters in body
Feb
19
comment How to efficiently create a new PRIMARY KEY CLUSTERED definition online
As you mentioned, I was hoping for something a little bit more all-in-one-go. It's not "fast", but your solution will work and it will keep everything online.
Feb
18
revised How to efficiently create a new PRIMARY KEY CLUSTERED definition online
improving last sentence
Feb
18
comment How to efficiently create a new PRIMARY KEY CLUSTERED definition online
@AaronBertrand I guess I'm trying to say that ideally we want our applications to keep working (inserting and reading) with as little interruption as possible - so really fast and/or online.
Feb
18
revised How to efficiently create a new PRIMARY KEY CLUSTERED definition online
added 111 characters in body
Feb
18
asked How to efficiently create a new PRIMARY KEY CLUSTERED definition online
Dec
11
answered List all the MS SQL Server Objects ->LinkedServers->Providers using SQL
Sep
15
awarded  Nice Question
Aug
13
awarded  Yearling
Aug
13
accepted Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Aug
13
comment Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Thanks @RemusRusanu. While this example is partially contrived to demonstrate the changed behavior, your tip is one we'll keep in mind as we design our services and queues.
Aug
13
comment Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
@MaxVernon we're running 12.00.2370
Aug
13
revised Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
minor clarification
Aug
13
asked Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Aug
13
accepted Efficiently Filter Large Set With Disjunctions
Aug
4
awarded  Notable Question
Apr
4
awarded  Popular Question
Aug
29
awarded  Scholar
Aug
29
accepted Quickly change NULL column to NOT NULL
Aug
29
comment Quickly change NULL column to NOT NULL
@MartinSmith I clarified what I mean by forever. I'm testing this in a dev environment with no other sessions hitting the database. It does eventually complete. But the answer that you linked explains why it takes so long. If you can reword your comment as an answer, then I'll accept it.