Viewing 15 posts - 3,571 through 3,585 (of 49,552 total)
Extended Events. https://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/
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
February 18, 2016 at 4:06 am
I suspect it's because you are not the replication process, and hence your inserts are treated normally,
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
February 18, 2016 at 3:56 am
er.mayankshukla (2/18/2016)
I guess even in Sql 2000 bookmark lookup refers to either key Or RID
Err, yes, that's what I just said.
What's called a bookmark lookup in SQL 2000 and before...
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
February 18, 2016 at 2:27 am
Bookmark lookup = SQL 2000 and before name. In 2005 and above it's called either a RID lookup or a key lookup.
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
February 18, 2016 at 2:04 am
A lot of people mix up parameters and variables. The code posted has local variables, not parameters.
As written, the cause is likely lack of parameter sniffing (variables can't be sniffed),...
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
February 17, 2016 at 2:41 pm
They're probably polling sys.dm_os_waiting_tasks, or have an extended event session on wait_completed
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
February 17, 2016 at 2:30 pm
Steve Hood. (2/17/2016)
Finally, we don't know how much of your clustered index is in cache, which would make adding an index less beneficial and possibly harmful.
???
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
February 17, 2016 at 9:07 am
It's not Redgate that can decrypt it. The tool just makes it easy to do so. Anyone with sysadmin access can decrypt the procedures.
There's no way to encrypt 'securely'. SQL...
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
February 17, 2016 at 7:21 am
You can't index a varchar(max) and the index on the varchar(800) will only be useful if there's no leading wildcard, and maybe not even then.
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
February 17, 2016 at 7:06 am
sys.stats. sysindexes is deprecated. (yes, it holds most of the info, but has none of the post-SQL 2000 properties)
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
February 17, 2016 at 1:40 am
1) BoL does say there's overhead, and it can be quite nasty. It's IO-subsystem related, so moving snapshots (or the source DB) to a faster drive may help.
2) No, there...
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
February 17, 2016 at 1:38 am
ramana3327 (2/16/2016)
Hallengren script rebuild/reorg the indexes based on the Index fragmentation %. It has to run everyday
It doesn't have to. Run it when you feel you need to.
So we are...
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
February 16, 2016 at 2:17 pm
Cthulhu for president! Why vote for the lesser evil?
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
February 16, 2016 at 6:39 am
Any uncommitted modifications roll back and the connection is terminated. While rolling back, it shows as an active session in ROLLBACK. Whether the SELECT aborts immediately or not I'm not...
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
February 16, 2016 at 6:19 am
It's a system process, You can't kill it and you can't change what it does. Leave it alone.
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
February 16, 2016 at 5:00 am
Viewing 15 posts - 3,571 through 3,585 (of 49,552 total)