Viewing 15 posts - 5,221 through 5,235 (of 8,753 total)
Stuart Davies (5/22/2015)
SQLRNNR (5/21/2015)
crittergremlin
Bugger
May 22, 2015 at 12:51 am
Quick thought, normally use sys.dm_exec_describe_first_result_set and build the dataflow based on the output.
😎
May 21, 2015 at 9:39 am
Quick question, can you post the output of these two queries?
😎
SELECT
OSM.total_physical_memory_kb
,OSM.available_physical_memory_kb
,OSM.total_page_file_kb
,OSM.available_page_file_kb
,OSM.system_cache_kb
,OSM.kernel_paged_pool_kb
...
May 21, 2015 at 12:56 am
jordon.shaw (5/20/2015)
Thank you both for your help! Worked perfectly!!!Jordon
You are most welcome.
😎
May 20, 2015 at 1:42 pm
Alvin Ramard (5/20/2015)
Eirikur Eiriksson (5/20/2015)
Just one step left😎
USE TEMPDB;GO
SET NOCOUNT ON;
DECLARE @MY_TIME VARCHAR(100) = '2015-01-16T00:00:00.000-06:00';
SELECT CONVERT(DATETIMEOFFSET,@MY_TIME,127);
SELECT CONVERT(DATETIME,CONVERT(DATETIMEOFFSET,@MY_TIME,127),0);
Were you looking over my shoulder? 😉
As always Alwin:-D
😎
May 20, 2015 at 1:40 pm
Just one step left
😎
USE TEMPDB;
GO
SET NOCOUNT ON;
DECLARE @MY_TIME VARCHAR(100) = '2015-01-16T00:00:00.000-06:00';
SELECT CONVERT(DATETIMEOFFSET,@MY_TIME,127);
SELECT CONVERT(DATETIME,CONVERT(DATETIMEOFFSET,@MY_TIME,127),0);
May 20, 2015 at 1:37 pm
Just realized that the target data type must be DATETIMEOFFSET, otherwise it will throw errors in any conversion
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @MY_TIME VARCHAR(100) = '2015-01-16T16:06:14.577-06:00';
SELECT CONVERT(DATETIMEOFFSET,@MY_TIME,127)
May 20, 2015 at 1:31 pm
Quick thought, should be 21/121 for datetime/datetime2 + offset
😎
May 20, 2015 at 1:21 pm
GilaMonster (5/20/2015)
Eirikur Eiriksson (5/20/2015)
This would be the one that wants to fix ugly queries with a sprinkle of hint perfume when all that's needed is a good shower/rewrite.😎
It appears I...
May 20, 2015 at 1:03 pm
Ed Wagner (5/20/2015)
Eirikur Eiriksson (5/20/2015)
Grant Fritchey (5/20/2015)
Eirikur Eiriksson (5/20/2015)
GilaMonster (5/20/2015)
Eirikur Eiriksson (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!I could see this one coming miles away, surprised how long it took.
😎
If it's the one...
May 20, 2015 at 12:58 pm
Grant Fritchey (5/20/2015)
GilaMonster (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query...
May 20, 2015 at 12:56 pm
Grant Fritchey (5/20/2015)
Eirikur Eiriksson (5/20/2015)
GilaMonster (5/20/2015)
Eirikur Eiriksson (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!I could see this one coming miles away, surprised how long it took.
😎
If it's the one I'm thinking of, I...
May 20, 2015 at 12:45 pm
AND cmd NOT LIKE 'BACKUP%'
Guess you should add DBCC
😎
May 20, 2015 at 12:34 pm
SQLRNNR (5/20/2015)
Eirikur Eiriksson (5/20/2015)
SQLRNNR (5/20/2015)
GilaMonster (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a...
May 20, 2015 at 12:30 pm
GilaMonster (5/20/2015)
Eirikur Eiriksson (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!I could see this one coming miles away, surprised how long it took.
😎
If it's the one I'm thinking of, I hit that stage this...
May 20, 2015 at 12:26 pm
Viewing 15 posts - 5,221 through 5,235 (of 8,753 total)