Viewing 15 posts - 25,711 through 25,725 (of 49,552 total)
muthukkumaran Kaliyamoorthy (6/6/2011)
GailThis means if i have primary key (C.I) then the SQL will do the delete followed by an insert to the table and PK.
Only if your update...
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
June 6, 2011 at 5:50 am
Gaurang-Patel (6/6/2011)
I am getting same result you get on 32 bit system.i am able to...
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
June 6, 2011 at 5:30 am
Please answer the question I asked earlier.
GilaMonster (6/4/2011)
Is that hourly log backup part of the log shipping setup, or a separate log backup job that you're running?
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
June 6, 2011 at 5:30 am
muthukkumaran Kaliyamoorthy (6/6/2011)
Create table test (n int,name char(10))
Create table test1 (n int,name char(10),n1 int,name1 char(10))
insert into test values (1,'muthu')
insert into test values (2,'lutzm')
insert into test values (3,'gail')
insert...
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
June 6, 2011 at 5:18 am
Ok, let me try and clarify things.
In many cases SQL will implement an update as exactly that. An in-place update where it just changes the values in the row. This...
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
June 6, 2011 at 5:09 am
Post the output of DBCC Ind.
When I tried that I got exactly what I expected, two pages allocated to the table (16kB total), one of them being a 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
June 6, 2011 at 4:53 am
Did you try and see what happened?
For ownership SQL doesn't care in the slightest if the account is enabled, disabled, locked out, etc. It just has to be a valid...
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
June 6, 2011 at 4:51 am
What is it that you're concerned about?
Remember there's page header, row header and slot array, so even with a single tinyint, the row will be larger than 1 byte. There'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
June 6, 2011 at 4:31 am
Ok, you're talking about two different things here.
1) The sa account is well known and hence the account should be disabled in all SQL 2005+ servers.
2) To avoid unplanned escalation...
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
June 6, 2011 at 4:28 am
Why does it seem like it's not a good thing?
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
June 6, 2011 at 4:06 am
You'll need to write the MCTS exams first, they're a pre-requisite for the MCITP
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
June 6, 2011 at 3:25 am
The MCDBA certification was retired something like 3 years ago. It was a SQL 2000 certification, it's no longer available (as SQL 2000 is long out of support)
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
June 6, 2011 at 3:13 am
muthukkumaran Kaliyamoorthy (6/6/2011)
Gail, Got the link
What that says is IF the update is split into a delete/insert combo THEN the replication sends...
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
June 6, 2011 at 3:10 am
muthukkumaran Kaliyamoorthy (6/6/2011)
GilaMonster (6/6/2011)
An in-place update.@sqlzealot-81,
What gail told is
An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an insert.
So...
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
June 6, 2011 at 2:37 am
sqlzealot-81 (6/6/2011)
muthukkumaran Kaliyamoorthy (6/6/2011)
GilaMonster (6/6/2011)
An in-place update.
@sqlzealot-81,
What gail told is
An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an...
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
June 6, 2011 at 2:36 am
Viewing 15 posts - 25,711 through 25,725 (of 49,552 total)