network profile
| bio | website | |
|---|---|---|
| location | New York, NY | |
| age | 36 | |
| visits | member for | 2 years, 2 months |
| seen | May 7 at 16:54 | |
| stats | profile views | 41 |
|
May 6 |
comment |
SQL Server log file 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 |
SQL Server primary key create 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. |
|
Dec 3 |
comment |
Identify why a user can drop a database I can drop databases as that user. Yes. If you are asking if anyone has used the account meliciously I'd rather not wait to see. |
