12,366 reputation
22355
bio website jonseigel.com
location London, Canada
age 31
visits member for 3 years, 4 months
seen Dec 16 at 14:47

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


Nov
22
awarded  sql-server-2012
Nov
13
comment Service Broker User Does Not Have Permission to Send to the Service
When looking for the database user, make sure the context of the query is the user database, not master.
Nov
12
awarded  Nice Answer
Nov
12
comment Error after removing sql server 2008 R2 Express edition and instaling Entreprise edition: Unable to connect to MyHost\MSSQLSERVER
@Strassenger: You're welcome.
Nov
11
comment DBCC error reported
Patches, service packs, etc., sometimes (often?) do work inside SQL Server to update system objects. I suspect what you're seeing is simply a log of this work being done and it's nothing to worry about. If it happened during the time the patches were installed, and no error was reported by the installer, then I would ignore these messages completely.
Nov
11
answered Error after removing sql server 2008 R2 Express edition and instaling Entreprise edition: Unable to connect to MyHost\MSSQLSERVER
Nov
10
comment A transaction log grows unexpectedly
Look at the Disk Usage report -- it has a section that lists all the data and log file autogrowth events. Try to correlate the times with activity happening on the server. I suspect there's a long-running user process happening all in the same transaction.
Nov
4
comment Signal wait always high
What leads you to believe this is abnormal? I assume there is a workload running on the server, right?
Oct
24
comment What are the dangers of non-IT managers using improper database terminology
The other site would be a better fit because you can replace the idea of databases in the question with anything (i.e., "my boss doesn't understand how to communicate about x"). If the question doesn't get migrated automatically, I would encourage you to repost it on that site (perhaps making it a bit more generic per my example); I think this is an interesting and important question.
Oct
20
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.