Viewing 15 posts - 7,141 through 7,155 (of 49,571 total)
kevaburg (12/1/2014)
if I were you I would build a 2008R2 box, attach all of your user databases with new log files
SQL can't create new log files because the databases were...
December 1, 2014 at 6:51 am
Yeah, moving the database files without telling SQL where they've gone will result in the database being inaccessible....
If you're certain that the DB files are back in the correct place,...
December 1, 2014 at 6:03 am
For master, no. You cannot use the system databases from a previous version. Try to copy them over the SQL 2014 master and all you'll succeed in doing is preventing...
December 1, 2014 at 6:00 am
I don't want to see the entire thing. Read through it, identify all the errors relating to this database (they'll be close to the time when it went into the...
December 1, 2014 at 5:27 am
The SQL Agent error log is not particularly useful for database engine errors....
Open the SQL error log (not the SQL Agent log), post here (as text, not an image) all...
December 1, 2014 at 4:44 am
Open the error log. Find all errors relating to this database. Post them here.
DO NOT detach this database.
Don't restart the server.
Don't restart SQL
It means that SQL could not open all...
December 1, 2014 at 4:30 am
Are the files all in the same filegroup? Or are they in three different filegroups?
December 1, 2014 at 4:12 am
You may need to open a case with Customer Support then.
Never use the services app to change a SQL logon. Config manager is the only thing which should be used...
December 1, 2014 at 4:09 am
Where and how did you change the service account?
December 1, 2014 at 2:29 am
Doing so means that the secondary server must be licensed.
Also the disconnection that Gianluca mentioned. If there are log restores running every 15 minutes and a report takes 20...
December 1, 2014 at 2:16 am
Edvard Korsbæk (11/30/2014)
Because i have to do a lot of calculations with the dates.
Look up the DATEADD and DATEDIFF functions
You need a number representing the date.
Thats why.
So something like the...
November 30, 2014 at 2:54 pm
From that blog post:
The problem with these types of queries is that there is no stable plan. The optimal plan differs completely depending on what paramters are passed. The optimiser...
November 30, 2014 at 7:39 am
... Why? ...
Why do you want to convert numbers to dates and back?
Oh, and how you do it is pretty much the way you showed in your example
SELECT CAST(41960 AS...
November 30, 2014 at 7:31 am
Jeff Moden (11/28/2014)
It would be really cool if we could get MS to retrofit this to 2012 and 2014.
Snowball's chance in hell.
They don't back-port features, can't think of any...
November 30, 2014 at 7:28 am
river1 (11/28/2014)
What do you mean by stop using select?
I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and you won't have...
November 30, 2014 at 7:26 am
Viewing 15 posts - 7,141 through 7,155 (of 49,571 total)