Reputation
471
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 5
Newest
 Yearling
Impact
~47k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Nov
17
awarded  Yearling
Dec
27
awarded  Enlightened
Dec
27
awarded  Nice Answer
Nov
17
awarded  Yearling
Oct
12
comment MySQL Indexing VarChar
@eggyal: I think I at least implicitly addressed the filesort concern. Because the query is returning all rows of the entire table, the optimizer chose to bypass the index, which is a perfectly sensible option in this case.
Oct
12
answered MySQL Indexing VarChar
Mar
5
comment Rolling changes to production databases
I think you're missing the point of clustering. There is one and only one shared database on your common drive. There is no "offline" copy of the database on the passive server.
Feb
26
awarded  Enlightened
Feb
26
awarded  Nice Answer
Jan
18
comment Defragmentation - Rebuilding Indexes SQL Server 2005
Note that online index operations require the Enterprise Edition of SQL Server.
Dec
2
awarded  Supporter
Dec
2
comment How to find the date a login password was last changed in SQL Server 2008?
@JNK: Thanks for the warm welcome. :-)
Dec
2
answered How to find the date a login password was last changed in SQL Server 2008?
Nov
17
awarded  Teacher
Nov
17
awarded  Autobiographer
Nov
14
answered How to know if I am running SQL Server 2008 R2?
Feb
16
answered Regnerating an execution plan - is this a valid approach?
Sep
28
comment How to pass in parameters to a SQL Server script called with sqlcmd?
@Jeremy: Sorry for that goof. I edited my answer to include your correction.
Sep
28
answered How to pass in parameters to a SQL Server script called with sqlcmd?