GilaMonster (8/2/2014)

---

Also need to keep in mind that CDC is Enterprise Only.

p.s. Nolock has side effects, it's not a go-faster switch that should be added to every single statement. Let's...

Thanks Gail and Erland, I was slightly (understatement) 😀 hasty responding before.

😎

Jeff Moden (8/2/2014)

---

I agree that SEQUENCE has the advantage of being able to cover multiple tables and that IDENTITY requires SET IDENTITY INSERT if you want to update the identity...

saxena200 (8/2/2014)

---

Really!

u may want to read the second line of the post dude!; BTW I believe I landed on the wrong place for this kind off question.

Thanks for reading that...

Jeff Moden (8/2/2014)

---

Here's what I'd use to solve this problem on my systems because it's short and accurate with the accuracy limits of DATETIME. No... it's not ANSI/ISO compliant...

Jeff Moden (8/2/2014)

---

Sean Lange (7/31/2014)

---

Sql server stores datetime as decimal. You can easily cast a datetime to decimal. But what is the point? What are you trying to do with...

Daniel Matthee (8/2/2014)

---

Hi Eirikur

I dont fully agree that it has the same flexibility.

For example in my suggestion i can create any date range as...

saxena200 (8/2/2014)

---

Hi,

As report model project is being deprecated in ss2012 - what are the alternatives available for us.

we have highly unstructured database (highly normalised and transactional in nature)

Tabular model is...

Nor being implied either,...

Jeff Moden (8/2/2014)

---

Eirikur Eiriksson (8/2/2014)

---

Update code

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @ITER INT = 0 ;

DECLARE @COUNT INT = 100000;

DECLARE @NextId INT = 0...

TomThomson (8/2/2014)

---

Evil Kraig F (8/1/2014)

---

If you want to lock rows for the duration of a transaction from being read, or better keep anyone else from getting into the table at...

This is simple, run the query with "Results to Grid", right click on the results and select Save Results As..

😎

Just to further on the explanation with a quick example:

😎

USE tempdb;

GO

CREATE TABLE dbo.MY_IDENTIY

(

MY_IDENTITY_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT...

Did you look at Greg's Robidoux article Using SQL Server DMVs to Identify Missing Indexes[/url]?

😎

Would have thought it would be in the sys schema in the master database, that is master.sys.sp_MSdistribution_cleanup

😎