Viewing 15 posts - 4,141 through 4,155 (of 8,416 total)
Lamprey13 (4/6/2010)
If you have triggers on your table thay could affect the value of @@ROWCOUNT, so just be aware of that.
There are a number of scenarios where @@ROWCOUNT may produce...
April 6, 2010 at 1:42 pm
vk-kirov (4/6/2010)
Paul White NZ (4/6/2010)
The primary purpose of TRUNCATE TABLE is to delete records - clearly a DML.
Not so clear to Oracle guys 🙂
http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_1001.htm – TRUNCATE is in the DDL...
April 6, 2010 at 1:39 pm
halifaxdal (4/5/2010)
Can anyone tell me where is the login user's ip address? can that be linked with principal_id in sys.server_principals or any where in trace file?
The user's IP address (if...
April 6, 2010 at 1:33 pm
Al B (4/5/2010)
Any thoughts would be greatly appreciated. If I'm barking up the wrong tree, I'd love to hear some alternate solutions.
The problem here is not one of being deterministic...
April 6, 2010 at 1:27 pm
Seems an odd question, but anyway:
select id,
name,
row_number() over (partition by id order...
April 6, 2010 at 12:48 pm
Judging from the picture of the query plan, it seems likely there are many ways to improve the performance...but I can't give any more detail without more detail from you....
April 6, 2010 at 12:41 pm
rambilla4 (4/6/2010)
But you are telling 10 threads per processor? Could you please clarify me which is correct?
There is no one 'correct' value - it depends on the application - I...
April 6, 2010 at 12:25 pm
Marts (4/6/2010)
April 6, 2010 at 12:19 pm
TheSQLGuru (4/6/2010)
That's what I get for trying to rush out a few posts before taking my daughter to school - missed several points! Thanks for clarifications Paul. 🙂
Absolutely...
April 6, 2010 at 12:16 pm
pablavo (4/6/2010)
April 6, 2010 at 7:48 am
Steve Jones - Editor (3/26/2010)
We are open. I built the levels during baseball season, so that is why some of them are what they are.
SSC-Insane :laugh:
What's baseball? :unsure:
April 6, 2010 at 7:43 am
bcp and BULK INSERT are not the only methods, and are not necessarily minimally-logged.
For full, and accurate, details see:
Importing and Exporting Bulk Data (Books Online link)
Be sure to explore the...
April 6, 2010 at 7:40 am
rafa.aborges (4/5/2010)
Another question: does anybody know why Microsoft doesn't make this feature enabled by default?
I read that the reason is the 'principle of least surprise' 🙂
By not changing default behaviour,...
April 6, 2010 at 7:36 am
bndgyawali (4/6/2010)
if
update tbl1 set col1='Y' where col2='xyz'
updates one or more rows, then i need to execute one set of statements. if this doesn't update any rows, then...
April 6, 2010 at 7:30 am
GSquared (4/6/2010)
Nope. Just felt like chiming in on it anyway.
Fair enough 🙂
April 6, 2010 at 7:24 am
Viewing 15 posts - 4,141 through 4,155 (of 8,416 total)