Viewing 15 posts - 5,686 through 5,700 (of 49,552 total)
Lynn Pettis (6/4/2015)
Alvin Ramard (6/4/2015)
Jeff Moden (6/4/2015)
Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think...
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
June 4, 2015 at 12:40 pm
You'll probably get a better answer on the MySQL forums. This site is for Microsoft SQL Server.
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
June 4, 2015 at 7:36 am
ramana3327 (6/4/2015)
1) Is there any relation b/n this log file growth and replication failure
Probably not. Replication can cause log file growth if the distributor is down, the subscriber's status doesn't...
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
June 4, 2015 at 7:34 am
*sigh*
I swear some people don't actually want help.
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
June 4, 2015 at 6:59 am
mohanaprabhu.v (6/4/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
June 4, 2015 at 6:57 am
I believe Chris asked for the execution plan already. Table definitions and index definitions are also kinda useful.
Why a left join? Do you really have invoices that don't have customers?
Why...
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
June 4, 2015 at 6:17 am
New questions in a new thread please.
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
June 4, 2015 at 5:33 am
You can, but personally I don't like that approach. It means you may see different behaviour to in prod, when the plans are cached.
Instead just ignore durations/times of 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
June 4, 2015 at 5:31 am
BL0B_EATER (6/4/2015)
GilaMonster (6/4/2015)
BL0B_EATER (6/4/2015)
GilaMonster (6/4/2015)
HookSqlDba7 (6/3/2015)
But, how often does this configuration updates the statistics?
When the number of rows that have changed since the last stats update exceeds 20% of 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
June 4, 2015 at 4:25 am
BL0B_EATER (6/4/2015)
GilaMonster (6/4/2015)
HookSqlDba7 (6/3/2015)
But, how often does this configuration updates the statistics?
When the number of rows that have changed since the last stats update exceeds 20% of the table (by...
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
June 4, 2015 at 4:20 am
HookSqlDba7 (6/3/2015)
But, how often does this configuration updates the statistics?
When the number of rows that have changed since the last stats update exceeds 20% of the table (by default, 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
June 4, 2015 at 2:55 am
You're probably going to have to do it in a two step process. Install SQL 2008 R2, migrate the DB to there, change the compatibility level, then migrate again 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
June 4, 2015 at 2:44 am
Will have to be later, office internet access going down in 3...2....1.....
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
June 3, 2015 at 9:44 am
DECLARE @TierID INT = 1;
DECLARE @Range INT = 1
SELECT s.TierLevelId
FROM dbo.sampletbl AS s
INNER JOIN (SELECT s.TierId,
...
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
June 3, 2015 at 9:01 am
Siva Ramasamy (6/3/2015)
If I am given TierId of 1 and Range value of 15, the query should return 3.
Why? 15 is not between 6 and 9
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
June 3, 2015 at 8:51 am
Viewing 15 posts - 5,686 through 5,700 (of 49,552 total)