850 reputation
1021
bio website
location New York, NY
age 37
visits member for 3 years, 8 months
seen Jun 3 at 13:53

May
6
asked Log file growth issues
Apr
19
comment Clustered vs Nonclustered Index
@ThomasStringer - Thanks Thomas
Apr
19
accepted Clustered vs Nonclustered Index
Apr
19
comment Clustered vs Nonclustered Index
A large majority of the records will meet the Null criteria specified. Would I still want to use teh filtered index for this? I thought filtered indexes were most useful if they narrowed down the amount of records by a significant margine.
Apr
19
comment Clustered vs Nonclustered Index
Yes Sorry SQL Server 2008 R2
Apr
19
asked Clustered vs Nonclustered Index
Apr
10
awarded  Popular Question
Mar
20
accepted Appropriate Action for Dead Locks / Blocking
Mar
20
comment Appropriate Action for Dead Locks / Blocking
@AaronBertrand - Yeah felt unwise to me too. Thats why I asked. I'm trying to figure a solution that allows me to react quickly before the website starts timeing out on customers. This was the solution suggested by my boss. I put the brakes on till I could get some more research done.
Mar
20
asked Appropriate Action for Dead Locks / Blocking
Mar
12
comment Query to determine a count by rolling interval
That'll do it. Thanks Sebastian.
Mar
12
accepted Query to determine a count by rolling interval
Mar
12
revised Query to determine a count by rolling interval
added 241 characters in body
Mar
12
comment Query to determine a count by rolling interval
yes the select is simulating when the messages would have gone out. Each count of 1 would be a message that would have been sent. So in the sample data abover I would want to count the first and third row because they are each more than 7 days appart.
Mar
12
asked Query to determine a count by rolling interval
Mar
12
answered Track grant permission on tables
Mar
8
accepted Load Testing Crash Course
Mar
8
asked Load Testing Crash Course
Mar
4
awarded  Self-Learner
Mar
4
comment Will a primary key be added as a clustered index?
Thanks Aaron. Thats what I thought but when unsure... Ask the experts.