Viewing 15 posts - 11,491 through 11,505 (of 49,552 total)
No difference at all. The IN is expanded into ORs in parsing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 8:36 am
ORs don't cause scans. ORs with inadequate indexing however have no way to execute other than a table scan.
http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 8:23 am
GRANT is for granting permissions to a role, user or login, not for adding a role, user or login as a member of a role.
From BoL
sp_addrolemember (Transact-SQL)
Adds...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 8:21 am
Anyone want to help on the blocking thread?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 8:15 am
What do you mean there's no chance? That's how you stop the SQL Server service, from there (preferably) or from services.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 8:14 am
Not enough information to help. Exact statement that is being blocked. Exact statement (not batch) that is causing the blocking. The Wait time. The exact lock types. The object names....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 8:14 am
Ok, so something (unknown) is causing something else (unknown) to be blocked for (unknown) duration with (unknown) lock types requested and (unknown) lock types held on (unknown) objects.
Good luck fixing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 7:33 am
Jack Corbett (9/30/2013)
GilaMonster (9/27/2013)
Thursday at Summit is going to be sooo funny. Just saying...
Okay, I need some more info on this one. I don't see anything on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 7:19 am
Stop shouting at us please.
Yes, blocking is possible. It should be short-lived. It's very hard to help you as you're not giving us much in the way of details. No...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 7:19 am
Wish it was like that here. Was an unexpected slump late May, early June. I'm not the only one seeing it. Have two friends, one has just found his first...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 6:55 am
John Mitchell-245523 (9/30/2013)
Have you tried to use sys.dm_os_waiting_tasks to see which session is doing the blocking?
?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 6:52 am
It's got nothing to do with recompiles, the schema change did invalidate the old plan (schema changes always invalidate all plans relating to that table) and SQL did compile a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 5:10 am
The message implies that the database was in single user mode at the time the backup tried to run. Check for other jobs setting it to single user, check in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 4:45 am
Master is damaged. You'll need to rebuild the system databases, then once SQL starts restore your backups of the system databases to get all your logins and other stuff back.
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2013 at 4:03 am
*sigh*
🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2013 at 6:32 pm
Viewing 15 posts - 11,491 through 11,505 (of 49,552 total)