850 reputation
1021
bio website
location New York, NY
age 37
visits member for 3 years, 10 months
seen Dec 18 at 16:03

May
23
comment View column has an 8000 character limit?
@AaronBertrand - I've edited to give more information and bring the post up to date as requested.
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
Apr
19
comment Clustered vs Nonclustered Index
@ThomasStringer - Thanks Thomas
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
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
12
comment Query to determine a count by rolling interval
That'll do it. Thanks Sebastian.
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
4
comment Will a primary key be added as a clustered index?
Thanks Aaron. Thats what I thought but when unsure... Ask the experts.
Mar
1
comment Pull Access schema into a SQL Server table
The assembly that is failing is a visual basic procedure. Unfortunatly the Ace Driver is failing to connect to the DB for him but the same driver is working fine with my linked servers. We've been through tons of support and work with the assembly and at this point were looking to see if there is another option
Feb
7
comment identify blocking and send alert
@Aaron Bertrand I can't stop smiliing. That was done very well. I'll look into it. Albeit I doubt I'll be able to get any expenditures past my boss at the moment.
Feb
7
comment identify blocking and send alert
@Aaron Bertrand that sounds great. Are there any that you recommend?
Feb
5
comment comma delimited column fix
Thanks. Yes the UI is expecting to do DML against the view. I'll read the link
Feb
5
comment comma delimited column fix
@Martin Smith - Excellent question. The queries include data modification statements.
Feb
5
comment comma delimited column fix
@Thomas Stringer - I've updated the question with the information
Jan
28
comment Invalid use of side-effecting operator 'INSERT EXEC' within a function
Aaron Bertrand - I'm looking to send in a SQL query as @SQL and return a delimited list of the results.
Jan
28
comment Invalid use of side-effecting operator 'INSERT EXEC' within a function
Lamark - so I would want to use a stored procedure to accomplish this then it sounds like.
Jan
8
comment Advice about Backup Solution
Thanks Thomas. It's not that we can't do a full backup. A full backup or differentials by themselves don't get me much further than the file level. Sounds like I need to talk to them about how long they store the transaction log backups for and make sure I can get a hold of them.
Dec
3
comment Identify why a user can drop a database
It was the Alter any Database permission
Dec
3
comment Identify why a user can drop a database
it was the alter any database permission. Thank you.