Viewing 15 posts - 1,036 through 1,050 (of 3,348 total)
Forgot to add this. Despite what the consultant says, there's nothing that holds you from using full recovery and taking log backups. As Jeff already mentions, SQL Server will always...
January 26, 2016 at 12:48 pm
Johan Buis (1/26/2016)
Question:What do you think, is the argument put forward by the consultant a good reason to stick with the simple recovery model?
My blunt answer is that the argument...
January 26, 2016 at 12:44 pm
mw112009 (1/26/2016)
See attached, I ran the sql you sent.
Also in my original post I have question#2.
That is:
IS there a way for me to do an update without SQL...
January 26, 2016 at 12:37 pm
Absolutely not. They *should* have that permission, because you want devs to learn to tune their queries. As a DBA, you'll have your hands full with the beasts that are...
January 26, 2016 at 12:16 pm
Stephen Grimshaw (1/26/2016)
I'm a bit surpised at the behaviour when a number appears in the brackets. Wasn't it once the case that a number would have been interpreted as colid?
No,...
January 26, 2016 at 6:44 am
nm.rajesh (1/25/2016)
Apologies for wasting your time , I have given the wrong table and insert statement i have Now corrected them in the below queries :
No apologies needed, everyone can...
January 26, 2016 at 5:09 am
Grant Fritchey (1/25/2016)
What blockers are you seeing for Azure?
What blockers...
January 25, 2016 at 2:39 pm
Ed Wagner (1/24/2016)
jonathan.crawford (1/23/2016)
January 25, 2016 at 2:33 pm
sqlnewbie17 (1/25/2016)
Can I have somethinglike this to color code a column (Current_Overdue)
=IIF(Fields!Blocked.Value=1 And Fields!Current_Overdue.Value = 0, ...
January 25, 2016 at 2:30 pm
Lowell (1/25/2016)
the parser didn't ignore anything. your DDL commands not separated by a GO statement. DDL and DML need to be seperate batches for the compiler to identify the changes.
Sorry,...
January 25, 2016 at 2:26 pm
Thanks for posting CREATE TABLE and INSERT statements, Rajesh!
Your explanation about the order of the data is also valuable: the data comes from an external source, you load it in...
January 25, 2016 at 2:06 pm
You don't reference the cell but the corresponding field in the data source. E.g.:
=IIF(Fields!Blocked.Value=1 And Fields!Current_Overdue.Value > 0, "Red", "Green")
January 25, 2016 at 12:52 am
mishka-723908 (1/24/2016)
Will this have the CTE recursion limit?
The solution Jeff posted uses CTE's, but no recursive CTE's. So no, it does not have a recursion limit. And it is known...
January 24, 2016 at 3:07 am
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
January 23, 2016 at 12:15 pm
hlrx (1/22/2016)
Not trying to be argumentative, but I understand how the process works, I'm just looking for a simpler solution.
Simpler then either adding "go" in between or submitting as two...
January 23, 2016 at 6:05 am
Viewing 15 posts - 1,036 through 1,050 (of 3,348 total)