Viewing 15 posts - 12,721 through 12,735 (of 49,552 total)
Ananth@Sql (6/18/2013)
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?
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/
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...
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...
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.
???
June 18, 2013 at 1:41 am
Chrissy321 (6/17/2013)
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...
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...
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...
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...
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....
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...
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?
???
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...
June 17, 2013 at 6:25 am
Viewing 15 posts - 12,721 through 12,735 (of 49,552 total)