Viewing 15 posts - 4,141 through 4,155 (of 49,571 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...
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...
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.
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.
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/
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...
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,...
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...
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...
December 1, 2015 at 1:51 am
Grant Fritchey (12/1/2015)
GilaMonster (11/30/2015)
Welsh Corgi (11/30/2015)
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.
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...
November 30, 2015 at 2:31 pm
Welsh Corgi (11/30/2015)
November 30, 2015 at 2:28 pm
In that case you need to do a UNION ALL between the selects of each table.
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.
November 30, 2015 at 1:54 pm
Viewing 15 posts - 4,141 through 4,155 (of 49,571 total)