shohelr2003 (11/11/2012)

---

Dear,

I have a database of 400 tables. I set the default size of database file is 20 GB and log file is 2.5 GB. These files are set to...

Grant Fritchey (10/22/2012)

---

sql-lover (10/22/2012)

---

I maybe wrong about this, but wanted to check or revise my own concepts.

I thought deadlocks (most of them) were due poor or bad code; a process...

-Check if you have open transactions. If that's the case, that space cannot be released.

-Try using T-SQL, instead of GUI. I do not know why, sometimes MS-SQL acts strange

*** EDIT...

GilaMonster (10/22/2012)

---

No, fragmentation will not cause deadlocks, neither will removing fragmentation resolve deadlocks.

Most likely the reason the deadlocks have gone away is that the rebuild also updates stats, which invalidates...

@lowell

... that is correct. I did not imply that. The table is there for historical purposes or data retrieval, and for...

Lynn Pettis (10/19/2012)

---

Create table statements from initial post:

CREATE TABLE dbo.MyTable_A(

c1 int PRIMARY KEY CHECK (c1 BETWEEN 12501 AND 1000000000),

c2 int IDENTITY)

GO

CREATE TABLE...

Lowell (10/19/2012)

---

sql-lover (10/18/2012)

---

Like I explained, the PK is a surrogate key. MS-SQL needs to generate the key itself, no manual intervention.

The real tables are more complex. I just simplified it...

Again,

It was an...

That is correct!

Like I explained, the PK is a surrogate key. MS-SQL needs to generate the key itself, no manual intervention.

Here's the modified code ...

IF OBJECT_ID ('dbo.MyTable_A') IS NOT NULL

...

Do I have to use SET IDENTITY INSERT on the trigger itself? When inserting, I am getting this error ...

Cannot insert explicit value for identity column in table 'MyTable_A' when...

Lowell (10/18/2012)

---

well, you identified the fix: creating an INSTEAD OF TRIGGER on the view, that inserts the data into the "right" table.

but if you don't want to use a trigger,...

davidwarner (10/9/2012)

---

I'm not good with AD but an issue i had was that during the install despite the domain service account used for the cluster having the right to create...

davidwarner (10/9/2012)

---

When you say that it's better to not create the AD/DNS accounts before setting up what draw backs specifically are you talking about? I have always setup Clusters creating...

After lot of testing, will go with this logic ...

DECLARE @i INT;

DECLARE @chunk INT;

DECLARE @maxNewTable INT;

SET @i = ( SELECT MIN(ID) FROM OldTable WITH (NOLOCK)...

bteraberry (10/3/2012)

---

while 1 = 1 loops just fine. It will break out of the loop when applicable because of the break statement.

My bad on @@ROWCOUNT ... that value should...