Viewing 15 posts - 1 through 15 (of 20 total)
Explanation is really weak. The answer is . . ., here is some code . . . see! The supplied link states nothing about delete cascade ...
March 24, 2015 at 7:09 am
Nice question, and able to finish lunch,
however . . .
I would have asked Junior why he didn't BACKUP the database for this purpose. BOL - "Reverting is not intended...
March 20, 2014 at 10:38 am
Scott Arendt (11/27/2013)
Koen Verbeeck (11/26/2013)VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files.Damn you Brent Ozar!
Koen Verbeeck (11/26/2013)
VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files.
Damn you Brent Ozar!
November 27, 2013 at 10:15 am
I'm not sure how far back this goes, but I...
November 13, 2013 at 9:46 pm
ummm, yes you can:
October 23, 2013 at 6:40 am
If one of the choices were 1,2, I might have gotten tripped up.
October 14, 2013 at 6:16 am
I don't even have 2012 installed yet, so I did some research, and found:
"A folder contains one or more projects and environments in the SSISDB catalog."
but the answer...
August 13, 2013 at 7:40 am
The topic is good, but it was easy only because the data and available answers were too simple. It would have been more challenging (what we all want I...
May 21, 2013 at 6:55 am
Firstly, does running the join query in SMS result in having lots of records, or just the 2 you listed.
At first glance it appears as if it were working as...
April 18, 2013 at 8:13 am
This why you certifiable and me grasshopper (insert bowing emoticon if there was one available)
April 18, 2013 at 7:37 am
I don't dispute the answer, but I don't completely agree, or understand the explanation;
"The total rows count will be 1*2*3=6! The summary of id3 will be 2*1+2*2+2*3=12! "
Yes, the row...
April 18, 2013 at 7:04 am
Caveat, I've never used or done this before but. . .
there is a Matrix.Columns Property available in SSRS, which will return the number of columns in the report. Based...
April 17, 2013 at 8:57 am
The most likely reason (details are lacking) you are having problems is that your parameter is a "multi-select", and in your SQL where clause, you are using "=" as the...
April 17, 2013 at 8:23 am
Use a Filter on each tablix, one for not nulls, the other for nulls (of course you need to use isNothing function in SSRS).
April 17, 2013 at 6:56 am
It appears that when you add a label to any of the available values, even if it is a Boolean, it defaults to a dropdown list. If you create...
April 16, 2013 at 9:09 am