Viewing 15 posts - 886 through 900 (of 1,079 total)
It's sometimes difficult getting the Manager to pay for training....especially when based on a client site.
Every individuals career lenght and training path is essentially linked to the duration of the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 11:23 pm
glad to be of some help.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 11:15 pm
Try....
Select * from dbo.DW_T_EC_JOB_TEMP t
where
t.EC_STEP_ID not in
(select j.EC_STEP_ID from DW_T_EC_JOB j
INNER JOIN DW_T_EC_JOB_TEMP t
ON
j.EC_STEP_ID = t.EC_STEP_ID)
--instead of--
--where (dbo.DW_T_EC_JOB.EC_STEP_ID = dbo.DW_T_EC_JOB_TEMP.EC_STEP_ID))
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 11:13 pm
This is my attempt to assist you 😀
DECLARE
@int date,
@idate datetime
SET @int = (SELECT CONVERT(date,getdate()))
SET @iDate = (SELECT CONVERT(datetime, @int))
SELECT @int AS Initial_Conversion, @idate AS Result
--or try CAST & convert
SELECT...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 10:15 pm
Now that you are on 2k8, use the excellent** new Activity Monitor to see which processes are taking long AND why?
check your SQL logs for any errors or infor messages...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 9:56 pm
run it 5 times each, and see if there is really a one second difference...each time..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 3:47 am
Call me a bit too serious, but I wouldnt take my eyes off the screen if I were you.
The mere fact that you "expect" something to fail, says a lot.
Rather...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 3:44 am
Should SQL 2005/8 be run on server hardware only and VM''s avoided?
I wouldnt say YES, or NO...but....
Depends on youre host (let's say ESX) you will be sharing resources with other...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 1:58 am
NP, glad it helped.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 12:30 am
How is SQL Server involved?
I'm also a bit confused Paul, just took a shot and hoped he meant, SQL notifications, to an outlook/exhange mailbox.
If not: this question doesnt make...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 12:13 am
I dont specifically for success/failure, but a log is kept.
There is a History tab on each Operator in SSMS 2005, which indicates most recent notification attempts.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 12:11 am
select @@version
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 12:03 am
youre first post
So I need to convert the varchar text/string date of 03/13/2010 into a date dd/MM/yyyy (with out the 00:00:00)
youre second post
So how can i get this...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 17, 2010 at 11:54 pm
My first question is: Why are you using date as string/varchar?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 17, 2010 at 11:34 pm
SELECT LEN('HOW LONG IS THIS DATA?')
RESULT = 22...
what you looking for?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 17, 2010 at 10:46 pm
Viewing 15 posts - 886 through 900 (of 1,079 total)