Viewing 15 posts - 9,196 through 9,210 (of 49,552 total)
Chowdary's (4/28/2014)
Still i am Expecting the Replies from Other Experts...
Did you bother to read the article I linked?
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
April 28, 2014 at 7:44 am
For the UK residents, what are my travel options for Birmingham -> Swansea?
Not yet certain if that's where I'll go, but may well be a place to start.
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
April 28, 2014 at 5:52 am
The DMV only contains stats for procedures whose plans are still in cache, so if the procedure hasn't run since SQL last started or the plan has since been aged...
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
April 28, 2014 at 5:45 am
If the index needs the clustering key to support the queries, explicitly add it. Don't rely on implicit behaviour.
So, an index for that query will be (Col1, ID) INCLUDE (Col2)
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
April 28, 2014 at 5:43 am
Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
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
April 28, 2014 at 5:42 am
It won't be due to CheckDB, it makes no changes to the DB.
Look for other stuff that changed. Make sure stats are up to date, the usual performance troubleshooting.
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
April 28, 2014 at 5:37 am
TomThomson (4/25/2014)
Steve Jones - SSC Editor (4/24/2014)
rodjkidd (4/23/2014)
Hope the op and recovery go well. You gotta make it over for SQL Bits.Rodders...
On the shed-dyule for Bits, and planning on 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
April 28, 2014 at 5:36 am
Perry Whittle (4/26/2014)
You'll also need to drop any constraints on the columns before you alter them, see books online for more detail
And possibly indexes as well.
As for data, offhand 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
April 26, 2014 at 12:38 pm
sysdatabases is deprecated and should not be used any longer. It's included only for backward compatibility with SQL 2000
Use sys.databases instead.
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
April 26, 2014 at 8:22 am
Original where clause predicate:
isnull(PF.Spend, 0) != 0
So, if any row has NULL for Spend, make that 0 and then look for rows where the resultant value is not 0. i.e....
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
April 26, 2014 at 8:20 am
If you change the database's default collation, then all that will happen is that new tables get the new collation by default. Nothing else changes.
If you want to change 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
April 26, 2014 at 8:13 am
What's the reasons behind the split? What are you trying to achieve?
Please in future start a new thread for your questions. 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
April 26, 2014 at 7:57 am
Start by tuning the queries. Partitioning is not a silver bullet.
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
April 26, 2014 at 7:56 am
GilaMonster (4/24/2014)
Table definitions, index definitions and execution plan please.
Can't do much without these
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
April 25, 2014 at 1:42 pm
smtzac (4/25/2014)
@Gila, I like to get your opinion is it normal log size?
There's no such thing. A log file size is dependant on transactional workload, recovery model and log backup...
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
April 25, 2014 at 1:41 pm
Viewing 15 posts - 9,196 through 9,210 (of 49,552 total)