Jon Seigel

less info
meta site favicon meta user | stack exchange network profile network profile
7,383 reputation
2832
bio website jonseigel.com
location London, Canada
age 29
visits member for 1 year, 10 months
seen 6 hours ago
stats profile views 384

SQL Server database developer and DBA.

In my spare time, I enjoy juggling, playing guitar, and working out.

Blog: http://voluntarydba.com, @VoluntaryDBA

Business inquiries: jon@jonseigel.com


199 Answers

newest activity votes
12
Are individual queries faster than joins?
may 24 at 17:56
10
Passing in the table into a stored procedure
jun 20 '12 at 14:52
9
System disk run out of space when running heavy SQL queries on SQL Server 2012
aug 2 at 21:58
9
Will a delete then insert within a transaction cascade?
jun 26 '12 at 15:49
9
Are heaps considered an index structure or are they strictly a table structure without index?
aug 15 '11 at 4:25
8
Adding a Clustered index to a HEAP table on someone else's app
nov 7 at 3:56
8
Composing the “ultimate database maintenance script”
aug 7 at 13:12
7
We are running database maintenace with indexing the system, indexing fails due to locking?
nov 30 at 18:10
7
Error when UPDATE all rows
oct 22 at 17:23
7
Is there any benefit to defragmenting SQL indexes in a SAN environment?
sep 5 at 17:07
7
which one is more efficient query?
aug 13 at 19:23
7
What is really wrong with this query please?
jul 20 '12 at 0:42
7
Is it possible to recover day's worth of queries from sql server log file?
jun 22 '12 at 18:31
6
Performance issues moving 1 million rows between tables
apr 29 at 14:05
6
SQL Server gets slow over time until we have to restart it
jan 1 at 16:44
6
Choosing the right algorithm in HashBytes function
feb 25 at 5:52
6
What to do with duplicate lookup information
feb 15 at 14:05
6
Should order of column in where clause be same as the index order?
sep 12 at 17:40
6
Broken NTFS Permissions for MSSQL$SQLEXPRESS
sep 7 at 17:46
6
Setting up a central CLR stored procedure / function respository library for internal stored procs in other databases to use?
aug 14 at 20:07
6
Write to Error Log
jul 5 '12 at 19:20
6
SQL server indexing foreign keys, covering indexes included columns
jul 2 '12 at 14:34
6
Update existing rows with squence number/char or any unique data
may 21 '12 at 12:56
5
SQL Server clustered index high fragmentation
may 15 at 17:27
5
SQL Server Sandbox
mar 22 at 16:53
5
High Buffer I/O SQL Server 2008 R2 causes?
mar 15 at 14:47
5
SQL Server media belongs to which edition
mar 2 at 15:59
5
Capturing datetime of change in SQL Server CDC
feb 4 at 18:54
5
Calling a .NET method in a SQL Server script
oct 30 at 11:26
5
Disabling logging on certain tables
oct 22 at 0:30
1 2 3 4 5 … 7