Eirikur Eiriksson

Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 8,753 total)

RE: Arithmetic overflow error converting expression to data type datetime.

Quick thought, to find the conversion causing the error, get the execution plan XML and look for an implicit cast to datetime. Also any value higher than 2958463 (9999-12-31) will...

August 21, 2014 at 10:27 am

#1739972
RE: Unable to reply to some forums

First noticed this yesterday, also sometimes the format changes, could be a separate CSS issue though.
Kind of annoying, spent about an hour writing an answer and then I couldn't...

August 21, 2014 at 10:08 am

#1739968
RE: Difference between INFORMATION_SCHEMA.COLUMNS and sys.columns

Lynn Pettis (8/21/2014)
Eirikur Eiriksson (8/21/2014)
Lynn Pettis (8/21/2014)
Eirikur Eiriksson (8/21/2014)
Quick note, INFORMATION_SCHEMA is an ANSI compliant metadata view collection added in 2000 if I remember correctly, sys.* is SQL Server specific.
😎
It...

August 21, 2014 at 10:01 am

#1739966
RE: Difference between INFORMATION_SCHEMA.COLUMNS and sys.columns

Lynn Pettis (8/21/2014)
Eirikur Eiriksson (8/21/2014)
Quick note, INFORMATION_SCHEMA is an ANSI compliant metadata view collection added in 2000 if I remember correctly, sys.* is SQL Server specific.
😎
It may be but it...

August 21, 2014 at 9:35 am

#1739957
RE: Difference between INFORMATION_SCHEMA.COLUMNS and sys.columns

Quick note, INFORMATION_SCHEMA is an ANSI compliant metadata view collection added in 2000 if I remember correctly, sys.* is SQL Server specific.
😎

August 21, 2014 at 8:13 am

#1739909
RE: SSIS issue

Make certain that the SQL Server 2008 R2 SSIS components are installed on the server, normally found under C:\Program Files (x86)\Microsoft SQL Server\100\DTS
😎

August 21, 2014 at 6:37 am

#1739860
RE: Parameter Sniffing

Quick thought, have you tried using WITH RECOMPILE?
😎
In addition, are the statistics up to date?

August 21, 2014 at 6:29 am

#1739856
RE: Compare two Table data and insert changed field to the third table

Phil Parkin (8/21/2014)
Maybe this would be a slightly better WHERE clause (handles NULLs)?
WHERE NOT EXISTS ( SELECT B1.[BedDays]
...

August 21, 2014 at 3:54 am

#1739819
RE: Compare two Table data and insert changed field to the third table

F/-\R//-\Z (8/17/2014)
hi
I try your code but this is not work!!!
no detect deferent row!
Here is the the code I previously posted with some sample data, works fine on my end;-)
😎
USE [tempdb]
GO
INSERT...

August 21, 2014 at 1:07 am

#1739781
RE: Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:16514; actual 0:0). It occurred during a read of page (1:16514) in database ID 8 at offset 0x00000008104000 in file 'G:\test\test.mdf'. Additional messages in the SQL Serve

anoosha.konaparthi (8/20/2014)
Again getting the same error after executing the above
Repeating Gail's request:
Please post the full and complete, unedited output of that CheckDB command. DO NOTHING ELSE FOR NOW!
If...

August 20, 2014 at 10:35 pm

#1739762
RE: Help with a join

Quick thought, this can easily be stuffed
😎
;WITH BASE_ID AS
( SELECT BID FROM
(VALUES (4461),(14130),(23891)) AS X(BID)
)
SELECT
BI.BID
,STUFF('CP000000000000'
...

August 20, 2014 at 10:25 pm

#1739761
RE: columnstore index issue

Paresh Motiwala (8/20/2014)
Hi SSCommitted,
I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.
Citing this as one of...

August 20, 2014 at 12:45 pm

#1739693
RE: columnstore index issue

Paresh Motiwala (8/20/2014)
I am just running a bench marking test. With and without columnstore indexes....
Columnstore index will not aid normal row retrieval, the test may therefore portray the negative impact...

August 20, 2014 at 11:37 am

#1739678
RE: columnstore index issue

Paresh Motiwala (8/20/2014)
This result should tell you:
...

August 20, 2014 at 9:37 am

#1739637
RE: Convert decimal(8,0) value to a time value

John Mitchell-245523 (8/20/2014)
Eirikur
Good points there. Hence, my new improved version 2. I've padded out TimeDecimal with another two zeros (that deals with the small numbers), then converted to...

August 20, 2014 at 9:12 am

#1739627

Viewing 15 posts - 7,441 through 7,455 (of 8,753 total)