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.
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 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...
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 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...
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 4:22 am
Lokesh Vij (6/17/2013)
DELETE FROM TableName with (TABLOCK)...
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 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...
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 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...
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 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.
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 16, 2013 at 12:08 pm
No. Completely incorrect approach.
Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/
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 16, 2013 at 12:06 pm
Of course.
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 15, 2013 at 2:10 am
Members of the dbcreator fixed server role can create, alter, drop, and restore any database.
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 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'
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 14, 2013 at 11:02 am
Query and execution plan down (kinda), table and index definitions still outstanding.
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 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'
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 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...
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 14, 2013 at 9:33 am
Please post query, table definitions, index definitions and execution plans.
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 14, 2013 at 9:32 am
Viewing 15 posts - 12,736 through 12,750 (of 49,552 total)