Viewing 15 posts - 34,276 through 34,290 (of 49,552 total)
Steve Jones - Editor (2/2/2010)
Thanks, never knew that. Does it apply from 2005->2008 as well?
I don't know for sure. If I had to guess, I'd guess no, because the changes...
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
February 2, 2010 at 8:30 am
roelofsleroux (2/2/2010)
As far as your opinion on the indexes goes, I'm pretty much happy with your statement that the Index on the composite key should be sufficient.
I did not say...
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
February 2, 2010 at 7:46 am
roelofsleroux (2/2/2010)
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
February 2, 2010 at 7:43 am
Steve Jones - Editor (2/2/2010)
However it just seems to be something that is recommended on migration/upgrade and "seems" to help. Why? No idea. Doesn't make sense to me either.
When upgrading...
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
February 2, 2010 at 7:42 am
Jeff Moden (2/1/2010)
Rebuild the clustered indexes, shrink the MDF, rebuild the clustered indexes again. Won't help the LDF, though.
Even that might leave the record on the hard drive in...
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
February 2, 2010 at 6:55 am
roelofsleroux (2/2/2010)
SELECT * FROM DATAS.tblDailyData
WHERE dbo.fnLKPInstrumentExchangeKey(InstrumentKey) = 4 AND DateKey = 20100101
I had to to make the where clause tak date into account otherwise it would...
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
February 2, 2010 at 6:53 am
Install SQL 2005 SP3. You should not be running RTM any longer.
Traceflag 1400 was provided for testing only. Don't use it in production environment, not supported (but then neither is...
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
February 2, 2010 at 2:56 am
Why are the queries using SELECT *? Do you really need every single column from the 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
February 2, 2010 at 2:52 am
EdA ROC (2/1/2010)
I don't follow the 'The create tables statements'
I want you to post the definition of the table. Yes, CREATE TABLE creates a table, that's why I want 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
February 2, 2010 at 2:46 am
Roberto Fonseca (2/1/2010)
How to use EKM outside SQL Server?
Please post new questions in a new thread. Thank 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
February 2, 2010 at 2:46 am
roelofsleroux (2/2/2010)
Gail: I have attached screenshot of the table structure, and execution plan for the following query
A picture of the execution plan is near-useless. It's just a pretty picture without...
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
February 2, 2010 at 2:43 am
Ask someone with sysadmin access to make a backup for you and restore it on the other server. All other database copy options will take ages and/or impost nasty 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
February 1, 2010 at 12:57 pm
EdA ROC (2/1/2010)
How do I post the schema with data types?
The create table statements
QUERIES That I Use
What is user activity?
SELECT * FROM useractivitylog
ORDER by userid, activity;
Who is using the reports?
SELECT...
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
February 1, 2010 at 12:54 pm
CirquedeSQLeil (2/1/2010)
Alvin Ramard (2/1/2010)
GilaMonster (2/1/2010)
Alvin Ramard (2/1/2010)
... this month? I hope not. It's only the 1st!!! 😀I think we'll all assume you meant January.
It's february already?...
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
February 1, 2010 at 11:24 am
Alvin Ramard (2/1/2010)
... this month? I hope not. It's only the 1st!!! 😀I think we'll all assume you meant January.
It's february already? Oh.
Fixed.
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
February 1, 2010 at 11:02 am
Viewing 15 posts - 34,276 through 34,290 (of 49,552 total)