Viewing 15 posts - 8,911 through 8,925 (of 49,552 total)
ramana3327 (5/26/2014)
So it is much better than insert into statement.
No, you can't conclude that.
They both can be minimally logged, the both hold the same locks.
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
May 27, 2014 at 2:11 am
Apples and watermelons
Joins are for when you want to relate two tables or subqueries. Apply is for when you want to run a function or subquery once for every row...
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
May 26, 2014 at 2:53 pm
Koen Verbeeck (5/26/2014)
Lynn Pettis (5/26/2014)
I think the answer here is hire a consultant.Not touching that one... 🙂
Filing that one under 'barge pole'
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
May 26, 2014 at 2:41 pm
You want agent alerts on all severity 20+ errors (you can set them on severity level) and on error 825. If you're doing checkDB once a week, make sure you...
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
May 26, 2014 at 2:37 pm
SQLRNNR (5/24/2014)
When thinking about it, you would have to recreate the partition function and scheme after each service restart or at least so it seems.
Or create them in Model.
Can't 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
May 26, 2014 at 8:18 am
Have you tested it out in a test environment? Was there a noticeable performance degradation? Have you had reliable reports of performance degradations caused by MDW?
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
May 26, 2014 at 6:06 am
GilaMonster (5/17/2014)
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
See the section on 'can't create the error log.'
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
May 26, 2014 at 5:47 am
Chowdary's (5/26/2014)
Can you pls share what are the main reasons for that.
A database will go into the offline state if someone explicitly sets it offline. Errors cause other states
If I...
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
May 26, 2014 at 4:39 am
Bhaskar.Shetty (5/26/2014)
Changing joins will not impact the speed of query.
It can. Apply used inappropriately can cause massive performance degradation.
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
May 26, 2014 at 2:33 am
Please post new questions in a new thread and give as much detail as possible. Thanks
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
May 26, 2014 at 2:16 am
mister.magoo (5/25/2014)
I seriously doubt you would find a trustworthy source that specifically states that you need to allow an extra 2GB for PAE.
Indeed, and it's very hard to find articles...
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
May 26, 2014 at 12:49 am
Right click database -> tasks -> bring online
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
May 26, 2014 at 12:46 am
ramana3327 (5/25/2014)
I think I can use outer apply to substitute left outer join, but I am not sure do we need to give column name like join
Suppose in left outer...
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
May 25, 2014 at 4:20 pm
Why? That's not the kind of query you'd use apply for. Apply isn't a magic performance enhancement.
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
May 25, 2014 at 4:19 pm
Lowell (5/23/2014)
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
May 25, 2014 at 4:18 pm
Viewing 15 posts - 8,911 through 8,925 (of 49,552 total)