178 reputation
8
bio website
location
age
visits member for 1 year, 9 months
seen May 29 at 23:52

May
3
awarded  Popular Question
Apr
22
comment SQL Server 2008 R2 installation device error
What version of Visual Studio? Also have you tried to assign a domain account to run the services?
Feb
4
answered Should I pause Mirroring and stop SQL Server services before running windows updates?
Jan
28
comment SQL Server Connectivity Issues
If there's nothing going on in the event logs then throw a perf mon capture session on the disk, nic, CPU, and memory. That should help localize the problem.
Jan
6
comment Speed up bulkinsert on sql server
Is it me or is everyone assuming that the hardware involved in the above scenario isn't the issue here? Not seeing any removal of hardware related issues as the source of the problem here.
Nov
13
answered How do I create a table with a column that uses a sequence?
Nov
13
comment How do I create a table with a column that uses a sequence?
@BrunoLM It depends on how big/small of a db we're talking about and how many transactions per second/minute we're talking about.
Nov
1
awarded  Citizen Patrol
Jul
18
answered What are the challenges of administrating an International stock trading database?
Jul
10
comment What is the most effective way to compress and store a SQL Server backup?
If the physical storage or tape drives aren't a concern, I'm curious as to what is the concern that compression is needed. There seems to be something missing here.
Jun
25
accepted How to enter multiple checkbox list items into database for eventual reporting
Jun
24
comment How to enter multiple checkbox list items into database for eventual reporting
@maxvernon I just updated the post with more information.
Jun
24
revised How to enter multiple checkbox list items into database for eventual reporting
added 1366 characters in body
Jun
24
comment How to enter multiple checkbox list items into database for eventual reporting
Ooops. I'll take care of that.
Jun
24
revised How to enter multiple checkbox list items into database for eventual reporting
added 10 characters in body
Jun
24
asked How to enter multiple checkbox list items into database for eventual reporting
Jun
17
comment SQL Server giving intermittant connection failures
Start with the individual counters LogicalDisk and Network Interface.
Jun
17
comment SQL Server giving intermittant connection failures
What sort of perf mon investigations have you done? I'd look at the NIC and disk right off the bat.
Jun
13
comment Home rolled gridview search results shows rows that are supposed to be ignored
Thanks for the explanation too. I really wanted to get under the hood and learn why its broken and what exactly it takes to make it work correctly.
Jun
13
comment Home rolled gridview search results shows rows that are supposed to be ignored
Because I programmed the sequence in this table to start at 500.