Viewing 15 posts - 5,341 through 5,355 (of 26,490 total)
sql-lover (5/1/2015)
Lynn Pettis (5/1/2015)
INSERT INTO #t
SELECT DOB, col2, col3 FROM OPENQUERY([Server1],'
SELECT top 1 @DOB, col2, col3
FROM MyDatabase.dbo.MyTable
WHERE col4 = @ZipCode
AND col1 = @DOB
ORDER BY MetricDate...
May 1, 2015 at 1:26 pm
sql-lover (5/1/2015)
I am tuning the following CPU intensive query, which is also a remote query for a given store procedure:
INSERT INTO #t
SELECT top 1 @DOB, col2, col3
FROM Server1.MyDatabase.dbo.MyTable
WHERE col4...
May 1, 2015 at 1:05 pm
jonathan.crawford (5/1/2015)
Jeff Moden (5/1/2015)
May 1, 2015 at 12:55 pm
roryp 96873 (5/1/2015)
I'm in too when that rolls around. Steve already created a thread for the 2015 season a while ago. He must have been excited.
Didn't see that...
May 1, 2015 at 10:51 am
Hey, I just got an email from Yahoo Sports. Looks like its time for more Fantasy Football!
Count me in for 2015!
May 1, 2015 at 8:28 am
ScottPletcher (4/30/2015)
ScottPletcher (4/30/2015)
Don't name the constraint, as constraint names have to be unique.ALTER TABLE dbo.test
ADD PRIMARY KEY CLUSTERED
( ReportRunTime, VisitID, SourceID, BaseID, OccurrenceSeqID, [DateTime], SeqID, QueryID, Response );
The original version...
April 30, 2015 at 1:01 pm
ScottPletcher (4/30/2015)
Don't name the constraint, as constraint names have to be unique.ALTER TABLE dbo.test
ADD PRIMARY KEY CLUSTERED
( ReportRunTime, VisitID, SourceID, BaseID, OccurrenceSeqID, [DateTime], SeqID, QueryID, Response );
Since you can name...
April 30, 2015 at 12:26 pm
lmacdonald (4/30/2015)
April 30, 2015 at 11:19 am
SQL-DBA-01 (4/30/2015)
Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?
use [AdventureWorks_2005]
SELECT * FROM dbo.sysFILES
OR
SELECT ...
April 30, 2015 at 11:15 am
Michael Meierruth (4/30/2015)
Pretty absurd this 'set dateformat' stuff.But I'll now vote for 'yyyymmdd' when hard coding dates.
Not really when you consider that this setting can be affected by how the...
April 30, 2015 at 8:40 am
Eric M Russell (4/30/2015)
set dateformat mdy;
select cast('2015-04-10' as datetime);
2015-04-10 00:00:00.000
set dateformat...
April 30, 2015 at 8:38 am
dany.fortier (4/30/2015)
Lynn Pettis (4/30/2015)
dany.fortier (4/30/2015)
YYYY-MM-DD is the format on the DBI try this SELECT ISNULL(MONTH(Anniversaire),''),'', Anniversaire FROM Tbl_RH_Pharmacie but got the same error, Am i doing it correctly &
Try...
April 30, 2015 at 8:35 am
Gail, iirc it may have been something I read in one of your posts or even a blog relating to temp tables in tempdb. Could you drop by this...
April 30, 2015 at 8:31 am
Viewing 15 posts - 5,341 through 5,355 (of 26,490 total)