374 reputation
114
bio website jonseigel.com
location London, Canada
age 31
visits member for 4 years, 10 months
seen May 26 at 15:36

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


Jun
5
revised IIS difference: Remove and Deploy -> Delete Site and Content
Edited tags
Jun
5
suggested suggested edit on IIS difference: Remove and Deploy -> Delete Site and Content
Oct
19
answered How to force a drop of MSSQL Server database
Oct
12
awarded  Popular Question
Oct
2
comment PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM
Just to verify -- the system page file is actually C:\pagefile.sys? Has the file-specific counter ever been above zero at any time?
Sep
24
comment Can only connect to sql server express 2012 via named pipes
Have a look at this answer: stackoverflow.com/a/11853321
Aug
16
comment MS SQL Server 2000 timeout error with no apparent cause
@gsteinert: Applications sometimes don't implement timeout settings correctly (because I've neeeeeever made that mistake myself... lol). Yeah, if you can see the end of it, I'd just as soon let it limp along until it goes away.
Aug
14
comment SQL Server error: Error: 802, Severity: 17, State: 20
What is the server's maximum memory setting set to?
Aug
14
answered MS SQL Server 2000 timeout error with no apparent cause
Aug
14
answered How to change default recovery for new databases?
Jun
3
comment Win Server 2008 R2 with Hyper-V and SQL Server
@wobblycogs: According to this, the limit for SQL 2008 R2 Standard is 64 GB; according to this (a bit old, but seems reasonable), Hyper-V supports up to 4 cores and 64 GB RAM per VM.
Jun
3
comment Parallel Processing in SQL Server 2008 R2
What do you need to scale out? Reads? Writes? Both? Reads are far easier to scale out than writes.
Oct
8
awarded  Yearling
Aug
15
awarded  Excavator
Jul
15
answered High CXPACKET wait type in SQL Server even with MAXDOP = 1
Jun
23
comment Database Backup and Full-Text Search
Did you try the registry changes? Seems pretty harmless to put it back if the change does nothing.
Apr
9
comment How to allow users to monitor performance of a set of servers without touching every server?
My point about Perfmon is that it requires permissions to be set on each individual box I want to monitor. I will check out the other two products. Thanks.
Apr
5
answered How do Resource Governer changes take effect after being set?
Apr
4
comment What can cause SQL Server's maximum memory setting to appear to change over time?
Yep, this is it. Looks like our memory allocation for SQL Server was a tad aggressive. Thanks!
Apr
4
accepted What can cause SQL Server's maximum memory setting to appear to change over time?