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...
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...
February 2, 2010 at 7:46 am
roelofsleroux (2/2/2010)
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...
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...
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...
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...
February 2, 2010 at 2:56 am
Why are the queries using SELECT *? Do you really need every single column from the table?
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...
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.
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...
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
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...
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?...
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.
February 1, 2010 at 11:02 am
Viewing 15 posts - 34,276 through 34,290 (of 49,552 total)