12,121 reputation
22353
bio website jonseigel.com
location London, Canada
age 31
visits member for 3 years, 2 months
seen 4 hours ago

SQL Server database developer/DBA.

In my spare time, I enjoy juggling, making music, and working out.

Personal (music): YouTube Channel | Facebook | @JonSeigel
VoluntaryDBA: Blog | YouTube Channel | Facebook | @VoluntaryDBA

Business/consulting inquiries: jon@jonseigel.com


1d
revised sql server service broker
edited tags
Oct
6
revised CTE returns an empty set even though anchor is non-empty
edited tags
Oct
6
comment Quickly restore test/QA SQL Server database
Good answer. For people finding this later, I want to draw attention to the Limitations and Restrictions section in that article -- the database as restored from a snapshot may not be restored to exactly the state one might expect (in particular, the behaviour around fulltext indexes). Snapshots are a great starting point for this type of solution, though.
Sep
30
awarded  Explainer
Sep
21
awarded  Notable Question
Sep
12
awarded  Enlightened
Sep
12
awarded  Nice Answer
Sep
11
awarded  Nice Answer
Sep
10
comment Service broker routes and DNS
I assume Service Broker got re-enabled on the database on Server C at some point?
Sep
3
comment reuse of temp table getting more time to execute
Are the number of rows in the temp table very different between the two calls?
Sep
3
comment Corruption in D:\$MFT. How may this progress? I don't think CHECKDB is useful here?
CHECKDB won't be able to resolve the problem, but it will tell you if part of the database can't be read from disk. Just knowing that may be very important in this situation.
Sep
2
revised Accessing Master database data into my database table
Fix formatting & tags
Aug
29
reviewed Approve suggested edit on calculating max and joining tables
Aug
28
comment Slow SQL Server authentication, but fast SAN, fast querying?
It's probably set too high; try lowering it. See my blog post here for more info: voluntarydba.com/post/2013/03/19/…
Aug
27
awarded  Enlightened
Aug
27
awarded  Nice Answer
Aug
22
comment Slow SQL Server authentication, but fast SAN, fast querying?
Swap file should never be used by SQL Server. You need to lower the maximum memory setting (or establish one if it's set to the default, which is unlimited). Fix this (reboot the box after changing it), and if that doesn't solve the problem, let us know.
Aug
22
comment How to use same stored procedure for different tables and avoid using dynamic sql
Why do you want to avoid dynamic SQL?
Aug
19
revised Copy database and clear down data (including linked tables) older than N days
edited tags
Aug
18
comment Change Data Capture missing changes for a specific record
CDC processes changes asynchronously. Does your logic account for that correctly?