always try to create your tempdb objects outside of a transaction (locking on tempdb)

A parent row can have more than one child rows in a child table....

EdVassie (12/1/2008)

---

This topic was discussed a few times at PASS, and the people who author SQL Server and the most experienced people in the user community are clearly saying you...

are there child tables that act as parent table for other tables ?

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

did you perform post-migration maintenance ?

/ * To be executed after a db-restore from a lower version than sqlserver 2005 !

*

*DATA_PURITY

* Causes DBCC CHECKDB to check the...

That's why it is considered a nation wide sports (over here) to try to avoid the rules whenever you can ... 😀

Do...

Grant Fritchey (11/30/2008)

---

Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First time in...

fwiw you insert an image column just like any other column.

insert into yourtable (yourimagecolumnname) values (@thevariable)

BOL will help you !

this may also give you useful information...

http://www.sqlservercentral.com/Forums/Topic608554-361-1.aspx

Well ..... since companies are currently experiencing the impact of the financial blunders all over the world....

They are prepared to take the risk !

The gamble is to see if...

euhm...

I would miss a declare statement !

Declare @BuildID integer

SELECT @BuildID = select top 1 BuildID

FROM Builds_LIVE

WHERE BranchID = @BranchID

AND ProductID = @ProductID

--if found

IF @@ROWCOUNT > 0

...

What I like most is that at SSC it is all being presented "feet on the ground" and open minded.

It did start its life from within the target public, attracted...

Coyote Blue (11/27/2008)

---

...

I have seen many people; with lots of letters after thier names, including VP and/or DIR, that do not understand the difference between a physically separate drive and...

btw:

Did anyone ever test the "ok i will determine the max value myself and add 1" .... and conclude sqlserver actually performs a FULL TABLE SCAN to resolve it.

afaik DB2...