Viewing 15 posts - 31,981 through 31,995 (of 49,552 total)
In SQL 2005 (which that link was for), no.
In SQL 2008 and 2008 R2...
Using INSERT INTO…SELECT to Bulk Load Data with Minimal Logging
You can use INSERT INTO <target_table> SELECT <columns>...
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
July 5, 2010 at 10:10 am
Jeff Moden (7/5/2010)
I'd personally never use a GUID for a PK.
I might, there are a few reasons.
Badly-designed front-end app needs to generate the surrogate key itself. Silly design, but it'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
July 5, 2010 at 9:50 am
stianl72 (7/5/2010)
I'am still a bit confused about the "minimaly logged" operations stuff.
http://msdn.microsoft.com/en-us/library/ms191244%28SQL.90%29.aspx
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
July 5, 2010 at 9:40 am
Chris Houghton (7/5/2010)
Am I correct in thinking that a checkpoint flushes the buffer to disk and by disk I mean the transaction log (ldf).
No. Checkpoint forces all dirty data...
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
July 5, 2010 at 9:34 am
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
July 5, 2010 at 9:23 am
Are you connected to the database that you're trying to detach? If so change your context to master.
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
July 5, 2010 at 8:19 am
Abrar Ahmad_ (7/5/2010)
My design strategy for a medium level transactional DB (10 K - 500 K data records/Day) would be to not implement foreign key constraints?
Half a million records a...
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
July 5, 2010 at 5:12 am
Either the index isn't selective enough or the query isn't SARGable.
Care to post the query and indexes?
As for links, check the index category on my blog.
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
July 5, 2010 at 4:40 am
Create a stored procedure that will generate the trigger code for each table, specific to that table and columns and doing what you want to do
It's still a 'general' trigger,...
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
July 5, 2010 at 4:37 am
Books Online?
http://msdn.microsoft.com/en-us/library/ms187956%28SQL.90%29.aspx
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
July 5, 2010 at 3:07 am
Or just
SELECT OBJECT_NAME(parent_id) FROM sys.triggers WHERE object_id=@@PROCID
No need for a TOP 1, the object_id is unique for first-class objects (anything that appears in sys.objects)
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
July 5, 2010 at 3:04 am
Steve Jones - Editor (7/4/2010)
As mentioned it doesn't matter. Don't worry about FKs ordering when putting columns in the table.
Don't worry about order of anything when putting columns in a...
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
July 4, 2010 at 11:43 pm
Well, it you think about the structure of star (and snowflake) schema, the fact table just contains the keys for the dimensions, not the entire dimension table (names and all...
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
July 4, 2010 at 11:40 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic947345-364-1.aspx
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
July 4, 2010 at 11:33 pm
Depends what he means by 'corrupted'
If he's talking about database corruption then you'll likely need to restore the database from backup as SQL throws high-severity errors when it encounters corruption.
If...
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
July 4, 2010 at 4:31 pm
Viewing 15 posts - 31,981 through 31,995 (of 49,552 total)