Viewing 15 posts - 5,131 through 5,145 (of 26,490 total)
Anyone with more knowledge of Log Shipping want to step into this one?
May 26, 2015 at 3:43 pm
Eric M Russell (5/26/2015)
Luis Cazares (5/26/2015)
Eric M Russell (5/26/2015)
A simple CAST operation from date/time to date won't necessarily prevent usage of an index on a date/time column. For example, given...
May 26, 2015 at 11:58 am
itmasterw 60042 (5/26/2015)
and if I run this:
Select dateadd(year,[Year]-1900,0)
from ##Shift
I get this (if it helps)
Select dateadd(year,[Year]-1900,0)
from ##Shift
Column1
2015-01-01
2015-01-01
2015-01-01
But I...
May 26, 2015 at 9:20 am
itortu (5/26/2015)
SELECT orderno
FROM _order
WHERE CAST(FLOOR(CAST(order_date AS FLOAT)) AS DATETIME)
BETWEEN CAST('5/14/2015' AS DATETIME)
AND CAST('5/15/2015' AS DATETIME)
ORDER BY order_date asc
The date will...
May 26, 2015 at 9:09 am
itmasterw 60042 (5/26/2015)
Hi,I saw the following and was woundering how it works? That is what does the -1900,0 do?
dateadd(year,[Year]-1900,0)
Thank you
A little ambiguous. What is the data stored in the...
May 26, 2015 at 9:04 am
Set SQL Server max memory. I watched a SQL Server 2005 EE development server die a slow and painful death because SQL Server starved the OS. Once I...
May 26, 2015 at 8:58 am
itortu (5/26/2015)
SELECT orderno, *
FROM _order
WHERE order_date >= '5/14/2015 00:00:00'
AND order_date < '5/15/2015 11:59:59'
ORDER BY order_date asc
I...
May 26, 2015 at 8:49 am
meilenb (5/24/2015)
No one is advocating shipping without testing so your comment on that matter is not correct.
From your statement here (emphasis mine):
ROI = (Gain from Investment - Cost of Investment)...
May 24, 2015 at 5:07 pm
meilenb (5/24/2015)
The assumption something is broken is not a valid assumption just because you disagree with a point.
Funny how people need to suggest...
May 24, 2015 at 2:50 pm
Something like this:
/*
ID AssID LocID PlacementDate
1112015-05-01
2122015-05-06
3132015-05-09
4212015-05-03
5222015-05-07
6232015-05-11
*/
declare @AssestPlacement table(
ID int,
AssestID int,
LocationID int,
...
May 24, 2015 at 2:44 pm
meilenb (5/24/2015)
It doesn't have to be broken to get it out the door.That is a false choice.
If it doesn't meet the customers expectations, or fails to meet the customers needs,...
May 24, 2015 at 1:41 pm
vivek.ghag52 (5/24/2015)
May 24, 2015 at 10:47 am
vivek.ghag52 (5/24/2015)
Even in my environment we need to purge the data from one of my table.But our concern is after purging my data will that reduce my data file...
May 24, 2015 at 9:52 am
Eirikur Eiriksson (5/22/2015)
Lynn Pettis (5/22/2015)
Stored proc parameter: @reportstring NVARCHAR(max)
DECLARE @tmpTbl TABLE ( value NVARCHAR(200) )
SELECT @tmp = ''
SELECT...
May 22, 2015 at 3:20 pm
Jeffery Williams (5/22/2015)
May 22, 2015 at 2:46 pm
Viewing 15 posts - 5,131 through 5,145 (of 26,490 total)