network profile
| bio | website | |
|---|---|---|
| location | New York, NY | |
| age | 36 | |
| visits | member for | 2 years, 2 months |
| seen | 2 hours ago | |
| stats | profile views | 42 |
|
2h |
asked | View column has an 8000 character limit? |
|
May 6 |
accepted | Log file growth issues |
|
May 6 |
comment |
Log file growth issues its a stored procedure that pulls data from a linked server access database and inserts it into a sql server database |
|
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 |
