Viewing 15 posts - 35,506 through 35,520 (of 49,557 total)
Firstly, why oh why are you shrinking your database?
Please run this on the DB in question, if it returns any errors post them.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
December 4, 2009 at 6:26 am
Grant Fritchey (12/4/2009)
More, absolutely more. The key values plus the include values plus the clustered key, it has to add up to more.
Depends what the key is. If it's...
December 4, 2009 at 6:20 am
The max/min settings are for the buffer pool. The buffer pool consists of the data cache, the plan cache and some other much smaller caches. The allocation of the buffer...
December 4, 2009 at 12:47 am
Try splitting into two procedures, but no need for two reports. Have the report call a wrapper proc that checks the parameters and calls one of two procedures to do...
December 4, 2009 at 12:38 am
The answer to that depends completely on how the table (if we are talking table partitioning) has been partitioned, what the partitioning key is and where the partition boundaries are.
December 4, 2009 at 12:35 am
Please don't cross post. It just wastes peoples time and fragments replies. There's no partitioning on SQL 2000, so putting this in the SQL 2000 forum is inappropriate anyway
No replies...
December 4, 2009 at 12:34 am
Garadin (12/3/2009)
a quick google informs me that the backup data structure changed between versions.
Not just the backup file structure. The actual database file structure. It is not possible to...
December 4, 2009 at 12:33 am
Does the maintenance plan log or SQL error log show something more useful?
December 4, 2009 at 12:25 am
Please post table definitions, index definitions and execution plans, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Root of your issue is parameter sniffing. The optimiser knows the value of the constant, it doesn't of the...
December 4, 2009 at 12:22 am
sashikanta.mishra (12/3/2009)
December 4, 2009 at 12:20 am
I didn't even notice that. Aliases are supposed to be applied after the select is evaluated (which is why you can't refer to an aliased column elsewhere in the SELECT...
December 3, 2009 at 10:49 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 3, 2009 at 9:30 am
Why do you want to change the name of a file of one of the system databases?
p.s. Please in future ask new questions in a new thread, rather than resurrecting...
December 3, 2009 at 9:15 am
Robert Frasca (12/3/2009)
That works fine so you're right, there's something subtle but I can't pinpoint it.
Weird.
Take out the three extra column that I added for testing, see if it still...
December 3, 2009 at 9:11 am
ajay.uce (12/3/2009)
What is Mirroring in SQL server 2005..How can i configure that in SQL server 2005 ?What is the difference between Log shipping and Mirroring ?
Is google down again?
December 3, 2009 at 8:47 am
Viewing 15 posts - 35,506 through 35,520 (of 49,557 total)