Viewing 15 posts - 1 through 15 (of 34 total)
Thanks Brian,
With a sql query by bringing all the tables together in a join, I am able to get exp_amount(fact table) broken down into exposure_cycles(dimension2). Why can I not get...
November 4, 2016 at 8:28 am
@PerryWhite, @gilamonster
I did the following test to see if Master database brings the keys & Cert along with it.
Server1: Has TDE encrypted user database DB1_tde_test.
Server2: Does not have...
August 6, 2014 at 11:36 am
@perry Whittle
Thanks soo much for your reply. I was very confused regarding the concepts. your answers addressed all the questions.
I have the following questions
1. Is there any...
August 5, 2014 at 9:18 am
@Mark-101232
The above script worked. Thank you.
August 23, 2012 at 10:51 am
How do I open the post. Need help on this "Reset to 1" trick to work.
August 23, 2012 at 9:53 am
The script does not work for this case
;with cte (temp_id, temp_test_id, temp_status)
as
(
select 1, 2, 'failed' union all
select 2, 2, 'failed' union all
select 3, 2, 'passed' union all
select 4, 17,...
August 23, 2012 at 9:13 am
@sean Lange
Iam having multiple values for test_status which I didnt mention in my 1st post.
I am having other status like rerun, non completed, investigate etc which I want...
August 22, 2012 at 2:58 pm
@david-2 Betteridge
Thanks. The second one works for me.
July 18, 2012 at 12:42 pm
@david-2 Betteridge
I dont want to insert any dummy values for the create_dt column.
The reason I want the column not null is for all the new rows I want...
July 18, 2012 at 12:08 pm
Hi Jonathan Kehayias
Thanks so much for the information. I guess extended events are not that useful to get Logical disk information. I shall use WMI scripting to get the information.
Thank...
January 31, 2012 at 7:08 am
Thanks for the reply. It is helpful
November 1, 2011 at 10:31 am
Got the code. Thank you
September 9, 2011 at 11:12 am
I actually want to return all the not null records if my obj_type is null. I dont want to return the first not null records.
For example I have 50 records...
September 9, 2011 at 10:00 am
The above code worked. Thank you.
September 9, 2011 at 9:45 am
Viewing 15 posts - 1 through 15 (of 34 total)