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

😎

You might want to try something like this:

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_PLANT

(

PLANT_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_PLANT_PLANT_ID PRIMARY KEY CLUSTERED

,PLANT...

Quick solution, returns the hour + time fraction (minutes and seconds / 3600)

😎

USE tempdb;

GO

DECLARE @DATE_VAL DATETIME = '2014-07-29 08:16:31.000'

SELECT @DATE_VAL

SELECT DATEPART(HOUR,@DATE_VAL) + (DATEDIFF(SECOND,'00:00:00.000',DATEADD(HOUR, - DATEPART(HOUR, CONVERT(time(3),@DATE_VAL)),CONVERT(time(3),@DATE_VAL))) / 3600.0)

Result

8.275277

Edit: Oops, feel...

Sean Pearce (8/2/2014)

---

GilaMonster (8/1/2014)

---

Sean, do you have the actual execution plan for comparison? I've seen obscene row estimations before, I suspect caused by the optimiser thinking that a one-to-many join...