Viewing 15 posts - 12,736 through 12,750 (of 49,552 total)
If you created the table on the 3rd filegroup then the table is on the 3rd filegroup. Default only applies when you don't specify a location.
June 17, 2013 at 5:03 am
Jeff Moden (6/17/2013)
then you could use TRUNCATE instead of DELETE and that will be minimally logged.
Technically truncate is fully logged. It just logs the page deallocations like a drop table...
June 17, 2013 at 4:45 am
balamurugan.devadas (6/17/2013)
we dont want log growing for deleting the records without affecting DB Mirror,how to handle this ONE?
Minimal logging is not a possibility, because deletes can't be minimally logged...
June 17, 2013 at 4:22 am
Lokesh Vij (6/17/2013)
DELETE FROM TableName with (TABLOCK)...
June 17, 2013 at 4:19 am
Joy Smith San (6/17/2013)
What are thr things that we need to do to speed up the index rebuild process ?..... in brief...
Better IO subsystem.
More memory (maybe)
Reduce the need to rebuild...
June 17, 2013 at 3:47 am
bslchennai (6/16/2013)
so please help me on how to avoid the deadlocks.
In general, write efficient queries and create indexes to support the app.
In specifics, turn traceflag 1222 on and post the...
June 16, 2013 at 12:11 pm
To be honest, dates shouldn't be stored in formats. They should be stored as a datetime data type and formatted when selected or in the application.
June 16, 2013 at 12:08 pm
No. Completely incorrect approach.
Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/
June 16, 2013 at 12:06 pm
Of course.
June 15, 2013 at 2:10 am
Members of the dbcreator fixed server role can create, alter, drop, and restore any database.
June 14, 2013 at 11:04 am
cpapas (6/14/2013)
I can't seem to attach a file to a post. All I see is the hyperlink option.
Below the text area, a button labled 'edit attachments'
June 14, 2013 at 11:02 am
Query and execution plan down (kinda), table and index definitions still outstanding.
June 14, 2013 at 10:49 am
GilaMonster (6/14/2013)
Please postquery, table definitions, index definitions and execution plans.
p.s. I'm not sure a 4-page long CTE qualifies as 'simple'
June 14, 2013 at 9:37 am
From Books online:
Permissions
Requires CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission.
Since you changed the question...
You GRANT any of the permissions listed above, or give the dbcreator role, which...
June 14, 2013 at 9:33 am
Please post query, table definitions, index definitions and execution plans.
June 14, 2013 at 9:32 am
Viewing 15 posts - 12,736 through 12,750 (of 49,552 total)