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])) ...
January 12, 2010 at 1:14 am
idiescreaming (1/11/2010)
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...
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...
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...
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...
January 11, 2010 at 12:35 pm
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...
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),...
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...
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...
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...
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...
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...
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...
January 11, 2010 at 8:10 am
Viewing 15 posts - 34,816 through 34,830 (of 49,552 total)