Viewing 15 posts - 7,141 through 7,155 (of 49,552 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...
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
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,...
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
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...
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
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...
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
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...
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
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...
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
December 1, 2014 at 4:30 am
Are the files all in the same filegroup? Or are they in three different filegroups?
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
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...
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
December 1, 2014 at 4:09 am
Where and how did you change the service account?
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
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
November 30, 2014 at 7:26 am
Viewing 15 posts - 7,141 through 7,155 (of 49,552 total)