Viewing 15 posts - 34,816 through 34,830 (of 49,552 total)
huhaoranxing (1/11/2010)
Thanks for your reply.And My test environment is sql server 2000 and Northwind.Products Table.
Then why is it posted in the SQL 2005 forum?
DEFINE: ([Expr1006] = [PROBE VALUE])) ...
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
January 12, 2010 at 1:14 am
idiescreaming (1/11/2010)
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
January 12, 2010 at 1:05 am
Lowell (1/11/2010)
count(*),count(someColumn) and count(1) are all the same as far as SQL server is concerned.
Not true at all.
Count(*) and count(<constant>) both count the number of rows in the resultset.
Count(someColumn) counts...
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
January 11, 2010 at 1:00 pm
sgambale (1/11/2010)
Yes, it truncates the unused part of the log prior to the oldest active transaction.
Not quite. Log's divided into sections. The sections can be active or inactive. Only 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
January 11, 2010 at 12:53 pm
Use the REVOKE statement to remove permissions.
Example
REVOKE SELECT on SomeTable TO Public
Specific statement depends on what the objects are.
Directly editing the system tables, even on SQL 2000, was 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
January 11, 2010 at 12:49 pm
GSquared (1/11/2010)
If I'm not mistaken, Oracle runs triggers once per row in the transaction.
Depends. Oracle has per-row and per-statement triggers. I have no idea which is the default (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
January 11, 2010 at 12:35 pm
You're gonna have to give us more details than that to work with. Table structure would be useful, as would some pseudo code, details on exactly what's happening.
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
January 11, 2010 at 9:15 am
What uses the primary key to filter/select by? If nothing, I'd suggest a 3-phase approach here.
1) Make the primary key nonclustered
2) Add a clustered index on the CreateDate column
3) Partition...
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
January 11, 2010 at 9:06 am
am-244616 (1/11/2010)
DECLARE @ID BIGINTSELECT @ID = ID FROM DELETED
Well, your code asks for only one value from the deleted table (which will have 4 rows if 4 rows were deleted),...
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
January 11, 2010 at 9:03 am
For future reference, please read through this for the best way to post to get fast replies. http://www.sqlservercentral.com/articles/Best+Practices/61537/
Now this isn't tested, cause no table structure was posted, but should work...
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
January 11, 2010 at 9:02 am
I would suggest you optimise your queries before starting to fiddle with locking and isolation levels.
Try these articles for starters
And, before you consider changing isolation levels, do some reading as...
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
January 11, 2010 at 8:45 am
Do note that what SSMS is doing here is creating a new table, copying all the data over, recreating all the indexes and constraints and dropping the old table. Fine...
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
January 11, 2010 at 8:27 am
gregory.anderson (1/11/2010)
Yes, this is 2005 enterprise edition, sp2 I believe.
Right now, the customer is receiving 5 9's of uptime and they are...
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
January 11, 2010 at 8:25 am
A full backup does not truncate the transaction log. Never has. A transaction log backup will contain the transactions since the last log backup.
The only time when a log...
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
January 11, 2010 at 8:16 am
Why do you want row locking there?
Before going that step, have you checked indexes?
Is this Enterprise Edition? If so, have you considered table partitioning. With a partitioned table, you...
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
January 11, 2010 at 8:10 am
Viewing 15 posts - 34,816 through 34,830 (of 49,552 total)