Viewing 15 posts - 11,086 through 11,100 (of 49,552 total)
All new features (well, vast majority) work in lower compatibility levels. Compat level just affects how the parser and query processor handle certain T-SQL structures that have changed over 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 3, 2013 at 9:55 pm
I'll give exactly the same answer as last time you asked this question (http://www.sqlservercentral.com/Forums/Topic1501909-1550-1.aspx)
Depends on the type of DBA, the company's needs and roles and the DBA's interests.
Someone who's more...
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 3, 2013 at 12:22 pm
A picture of the plan is fairly useless. Can you save the plan and attach the resultant file to your post?
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 3, 2013 at 11:16 am
I suppose you could insert the results of RESTORE FILELISTONLY into a table run an update to change the file paths, then write a script to generate a RESTORE from...
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 3, 2013 at 4:01 am
That's probably what I would have done. Why's it not a valid solution?
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 2, 2013 at 12:16 pm
Maybe put max server memory back to 14GB and leave it for a while, monitor available MB, watch the ring buffer for memory notifications, watch total and target server memory.
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 1, 2013 at 1:15 pm
Does SQL need more than it's currently allocating? Is there any indication of internal memory pressure?
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 1, 2013 at 1:06 pm
Is there free memory for SQL server to allocate?
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 1, 2013 at 12:56 pm
They don't have a script, they're not T-SQL. They're written in C++ and compiled into dlls which are shipped with SQL Server.
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 1, 2013 at 12:55 pm
Depends on how much data is going to be affected. It's not fixed. Couple of rows, row locks, fair portion of the table, probably page locks, most of 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
November 1, 2013 at 12:49 pm
Extended stored procedures are written in C++, they do things that T-SQL can't do.
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 1, 2013 at 11:34 am
Have a read through this: http://www.sqlservercentral.com/stairway/73776/, especially levels 3, 5 and 7
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 1, 2013 at 10:15 am
btw, restore from backup should have been the first thing you tried. Emergency mode repair is the last resort when all else has failed and you have no backup. It...
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 1, 2013 at 10:12 am
pradeep.k 50453 (11/1/2013)
its any possible to recover without restore the backup
No. Emergency mode repair failed. That's the absolute final resort, there are no more options left. Restore from your last...
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 1, 2013 at 10:07 am
Matt Crowley (11/1/2013)
From the error messages, it seems you have copied over all of the .MDF and .NDF files, but not the .LDF file.
Emergency mode repair is capable of...
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 1, 2013 at 10:06 am
Viewing 15 posts - 11,086 through 11,100 (of 49,552 total)