Viewing 15 posts - 4,741 through 4,755 (of 26,490 total)
drew.allen (8/4/2015)
Lynn Pettis (8/3/2015)
Just another way to do it:
declare @Date date = '20150803',
@Time time = '15:00:00';
select dateadd(second,datediff(second,0,@Time),cast(@Date as datetime))
go
I considered this approach,...
August 4, 2015 at 7:29 am
Just another way to do it:
declare @Date date = '20150803',
@Time time = '15:00:00';
select dateadd(second,datediff(second,0,@Time),cast(@Date as datetime))
go
August 3, 2015 at 2:22 pm
Eddie Wuerch (8/1/2015)
A terrific blog for reading the details found in sys.dm_os_ring_buffers (including the query you seek) may be found here:https://bwunder.wordpress.com/2012/07/29/monitoring-and-troubleshooting-with-sys-dm_os_ring_buffers/
-Eddie
Fixed link:
https://bwunder.wordpress.com/2012/07/29/monitoring-and-troubleshooting-with-sys-dm_os_ring_buffers/
August 3, 2015 at 11:49 am
Phil Parkin (8/3/2015)
Use Token to break the file name into the components you need and assign these components to other variables.
Add an ExecuteSQL task...
August 3, 2015 at 11:47 am
Alvin Ramard (8/3/2015)
SQLRNNR (8/3/2015)
Lynn Pettis (8/3/2015)
ok, thank you very much.
I inherited these databases so I'm very...
August 3, 2015 at 10:57 am
Read the following comment made today by Silver Spoon on a 4 year old thread:
ok, thank you very much.
I inherited these databases so I'm very green but thank you.
I will...
August 3, 2015 at 9:57 am
ben.brugman (8/3/2015)
August 3, 2015 at 9:28 am
ScottPletcher (7/31/2015)
Lynn Pettis (7/31/2015)
ScottPletcher (7/31/2015)
ZZartin (7/31/2015)
ben.brugman (7/31/2015)
Sean Lange (7/31/2015)
July 31, 2015 at 5:04 pm
ScottPletcher (7/31/2015)
ZZartin (7/31/2015)
ben.brugman (7/31/2015)
Sean Lange (7/31/2015)
July 31, 2015 at 4:16 pm
Sean Lange (7/31/2015)
Lynn Pettis (7/31/2015)
Sean Lange (7/31/2015)
ScottPletcher (7/31/2015)
Technically "usp_" is illogical, since "sp_" stands for "special", but "usp_" wouldn't be meant as "user special".
I would offer that a prefix of...
July 31, 2015 at 2:42 pm
ScottPletcher (7/31/2015)
Lynn Pettis (7/31/2015)
Sean Lange (7/31/2015)
ScottPletcher (7/31/2015)
Technically "usp_" is illogical, since "sp_" stands for "special", but "usp_" wouldn't be meant as "user special".
I would offer that a prefix of any...
July 31, 2015 at 2:41 pm
Sean Lange (7/31/2015)
ScottPletcher (7/31/2015)
Technically "usp_" is illogical, since "sp_" stands for "special", but "usp_" wouldn't be meant as "user special".
I would offer that a prefix of any kind is illogical...
July 31, 2015 at 2:26 pm
ZZartin (7/31/2015)
brett.robson 18562 (7/30/2015)
Yes, and you only let "your" people in. "Culture fit" is a synonym for bias.Is bias inherently a bad thing?
Depends. If done to suppress different ideas,...
July 31, 2015 at 9:29 am
The only thing that comes to my mind would require using Dynamic SQL. The difficult part would be knowing how to determine what is duplicated data? What columns...
July 31, 2015 at 9:14 am
Jim Zielinski (7/30/2015)
David.Poole (7/29/2015)
July 31, 2015 at 9:07 am
Viewing 15 posts - 4,741 through 4,755 (of 26,490 total)