Viewing 15 posts - 48,286 through 48,300 (of 49,552 total)
See the link in the menu mar (to the left) 'Write for us'? Everything you need is there.
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
October 30, 2007 at 5:50 am
In that specific example, sure, but not necessarily for triggers in general. Depends what you're trying to do with them. They have their place.
But back to your problem. My gut...
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
October 30, 2007 at 4:31 am
Peter Gadsby (10/30/2007)
If a trigger is executed on insert then every row that is inserted into the table will trigger the trigger, this will drastically reduce performance.
Sergiy's point is that...
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
October 30, 2007 at 3:30 am
I think all the installer does is drop the files in SQL's data directory. Assuming default installation, you'll find them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Go to management studio and attach...
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
October 30, 2007 at 2:17 am
No. you're checking for an error directly after the update statement, and if there is an error, you're rolling the entire transaction back (everything back to the begin tran)
p.s. Since...
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
October 30, 2007 at 2:08 am
I could be mistaken, but is that the default trace you're trying to delete?
If so, change the server's property to prevent it from starting. I don't think you can close...
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
October 30, 2007 at 1:31 am
My pleasure
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
October 30, 2007 at 12:17 am
Sandy (10/29/2007)
Hey Gail,I apology for that...:D
I didn't mean that.(he he he..lolz)
Is fine. I was fairly sure you didn't 😉
Actually Grant is one of my Fav member in this site.
Oooh, Grant,...
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
October 29, 2007 at 6:25 am
Common Table Expressions, despite their name, are not tables. Think of them as a temporary view that you can use to simplify a query. The 'temporary view' lasts for just...
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
October 29, 2007 at 6:02 am
Peter Gadsby (10/29/2007)
Update process1. Drop indexes on another TRANSFORM table
2. Create new indexes on other TRANSFORM Table
3. Add indexes on TRANSFORM_TABLE
4. Perform a number of updates from other TRANSFORM table.
I'm...
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
October 29, 2007 at 4:38 am
Peter, can you describe the ETL process, step by step, along with the durations and aprox data rows affected for each step. Without some idea what's happening, we're shooting in...
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
October 29, 2007 at 3:58 am
What more do you want to know on CTEs? Here's a good, albeit fairly technical, article on CTEs.
http://blogs.msdn.com/craigfr/archive/2007/10/18/ctes-common-table-expressions.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
October 29, 2007 at 2:39 am
I'll give this a try.
Temp tables
Behave just like normal tables, but are created in the TempDB database. They persist until dropped, or until the connection that created them disappears. They...
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
October 29, 2007 at 1:09 am
You've got quite a few table scans in that query (Address, Business_Service, Business_Service_Category, Business_Sub_Category). Without the schema I can't offer suggestions, but if those are large tables, you may want...
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
October 29, 2007 at 12:48 am
SG (10/26/2007)
Could it be a caching issue? Now we aren't using the server so much, nothing is...
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
October 29, 2007 at 12:25 am
Viewing 15 posts - 48,286 through 48,300 (of 49,552 total)