Viewing 15 posts - 4,141 through 4,155 (of 49,552 total)
I think you may have misread my answer.
If you have some custom monitoring that tracks users, then you will query whatever tables that custom monitoring writes to. If you have...
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
December 1, 2015 at 5:21 am
polkadot (12/1/2015)
Seriously, does any team really have discussions about these things?
Yes, good teams do, because they know that making time to establish standards and practices saves time later on.
If the...
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
December 1, 2015 at 5:14 am
If you have custom monitoring, query those tables. If you don't, then you won't be getting that info.
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
December 1, 2015 at 5:10 am
Help in resolving what problem? If you don't want to run the data purging scripts, then don't run them.
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
December 1, 2015 at 2:51 am
Once more with feeling... 🙂 Partitioning is not for performance. It's for data management.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
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
December 1, 2015 at 2:12 am
Me: Execution plans please
OP: You can use AdventureWorks2012
Well, yes I could, if I had it installed on the machine that I'm currently using (which I don't). Or I can spend...
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
December 1, 2015 at 2:08 am
ScottPletcher (11/30/2015)
In more detail, index "FDX_spG_NU_QA_V12" does not contain at least one of the columns:MC.col1 / MC.col2 / MC.col3
That won't cause the reported error. He said it's a filtered index,...
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
December 1, 2015 at 2:00 am
In that case, sounds fine. Not seeing any problems with it. 7.5 million rows is pretty small, so nothing to be concerned about there.
Proper indexing, definitely. Partitioning, maybe, remember it's...
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
December 1, 2015 at 1:55 am
You can't downgrade from one major version to another (SQL 2012 to SQL 2008 R2). Within a single version, it's usually OK in either direction as most service packs and...
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
December 1, 2015 at 1:51 am
Grant Fritchey (12/1/2015)
GilaMonster (11/30/2015)
Welsh Corgi (11/30/2015)
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
December 1, 2015 at 1:49 am
Sleeping means it has no work to do, there's no commands being run on that connection. So if can't go to running, it has nothing to run.
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
December 1, 2015 at 1:47 am
Still far too vague
If a row is inserted into table A and column B has some value other than null, then insert into another table?
If Column B is updated to...
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
November 30, 2015 at 2:31 pm
Welsh Corgi (11/30/2015)
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
November 30, 2015 at 2:28 pm
In that case you need to do a UNION ALL between the selects of each table.
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
November 30, 2015 at 2:25 pm
Yes, I am asking you for that information. We can't help you tune a query just by seeing the T-SQL of it.
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
November 30, 2015 at 1:54 pm
Viewing 15 posts - 4,141 through 4,155 (of 49,552 total)