12,032 reputation
22150
bio website jonseigel.com
location London, Canada
age 31
visits member for 3 years
seen 17 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


17h
reviewed Approve suggested edit on calculating max and joining tables
1d
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?
Aug
8
awarded  Yearling
Jul
29
revised How to move 200 materialized views without having to re-create in the new home
edited tags
Jul
23
reviewed Reject suggested edit on Inner Join or what else?
Jul
21
comment Database Structure Definiton
I would look into using a BI/analytics solution (such as SSAS) for this project; it might better meet the querying requirements.
Jul
21
revised Query Optimization required - Subquery using Inner Join
Consolidate comments
Jul
17
reviewed Approve suggested edit on Database mail “Mailbox unavailable. The server response was: 5.7.1 Unable to relay for…”
Jul
17
comment Database Structure Definiton
What do you plan to do with the data once it's in the database?
Jul
17
comment How to store lots of small text in a SQL Server database?
Also, IIRC, the max database size for Express edition was increased to 10 GB in 2008 R2.
Jul
17
comment How to store lots of small text in a SQL Server database?
When querying the data, do you actually need to look at the text contents to satisfy the query, or is only the metadata searched? If you don't need to search it, consider using CLR (or your application) to compress the contents before putting it into the database. Is the text data the same from row-to-row, or will it always be different? If it's the same quite frequently, normalize the structure and implement a large text hashing mechanism like I blogged about here.
Jul
17
comment SQL Server 2012: NUMA node shown as offline without special affinity settings
Interesting. Maybe with the licencing revamp they locked things down to the number of CPUs in Windows so you can only use each one in one instance. What happens if you shut down the instance assigned one NUMA node, and then start up or restart the other instance? Does it still use 3, or does it now use 4?
Jul
16
comment Security implications of restoring a backup from an unknown source?
@JNK: System error -9719 is sent to the queue when the database is attached or restored. See rusanu.com/2007/12/03/resending-messages
Jul
16
comment Security implications of restoring a backup from an unknown source?
Activation stored procedures. technet.microsoft.com/en-us/library/…