Viewing 15 posts - 12,721 through 12,735 (of 49,552 total)
Ananth@Sql (6/18/2013)
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
June 18, 2013 at 4:07 am
Why hide the fact that the error is occuring? Wouldn't fixing the error be a better 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
June 18, 2013 at 3:23 am
You need to examine the procedures using the EMP table and see what columns they're using.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
June 18, 2013 at 3:19 am
HildaJ (6/17/2013)
I was reading that on an average server the PLE is about 300 or 5 minutes.
Nope. Completely wrong. Anyone who says PLE should be 300 doesn't understand...
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
June 18, 2013 at 3:02 am
Ramana Reddy P (6/18/2013)
How i can remove partition from that singe table with out losing any data. I have 20 millions data in that table.
Rebuild the table and specify...
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
June 18, 2013 at 1:43 am
Jason-299789 (6/17/2013)
Once paritioned you shouldnt need to run any DBCC commands unless you are moving data and want to check the integrity afterwards.
???
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
June 18, 2013 at 1:41 am
Chrissy321 (6/17/2013)
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
June 18, 2013 at 1:36 am
suneet.tg (6/18/2013)
To overcome the recovery problem always shrink you log files.
No you can't. If the DB is in recovery the log can't be shrunk. Once the DB comes online 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
June 18, 2013 at 1:33 am
Dynamic SQL involved building up a SQL statement and executing that statement. All your code does is execute a specific stored procedure.
Dynamic SQL (though an obviously trivialised example):
DECLARE @sSQL NVARCHAR(4000);
DECLARE...
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
June 17, 2013 at 2:06 pm
Not in an in-line table valued function. If you want anything other than a single select statement, you need a multi-statement table-valued function, though be very careful as they don't...
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
June 17, 2013 at 1:56 pm
They're output parameters, parameters that are used to send information back to the caller.
See the CREATE PROCEDURE page in Books Online.
They have nothing to do with dynamic SQL, there's...
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
June 17, 2013 at 1:52 pm
SQLRNNR (6/17/2013)
SQLRNNR (6/13/2013)
You guys have a "widget" on your blog that allows the display of certain icons or badges (e.g....
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
June 17, 2013 at 1:38 pm
To enable compression, you have to rebuild the index. It will behave exactly as a normal index rebuild behaves, logging the full data size of the new index to 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
June 17, 2013 at 1:34 pm
Dird (6/17/2013)
Wouldn't "generate less logging" be more accurate since the logging to re-apply the truncate will also be logged?
???
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
June 17, 2013 at 6:25 am
You can't specify a location when inserting. You specify the location when creating the table. Wherever you specify the table to be created is where the table and all 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
June 17, 2013 at 6:25 am
Viewing 15 posts - 12,721 through 12,735 (of 49,552 total)