Viewing 15 posts - 1,996 through 2,010 (of 2,756 total)
Stuart Davies (3/13/2015)
SQLRNNR (3/12/2015)
droneBee
Happy
March 13, 2015 at 5:35 am
Gary Varga (3/12/2015)
March 12, 2015 at 11:02 am
The BOL example is just that, a very basic example.
You actually have the right idea, you would use transactions (explicitly) as a way to error handle inside a query or...
March 11, 2015 at 6:32 pm
Katerine459 (3/11/2015)
If a stairway ever does get created, I just wanted to give a...
March 11, 2015 at 1:01 pm
SqlSanctum (3/10/2015)
jasona.work (3/10/2015)
SqlSanctum (3/9/2015)
jasona.work (3/9/2015)
SQLRNNR (3/9/2015)
jasona.work (3/7/2015)
Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke...
March 10, 2015 at 7:48 pm
SqlSanctum (3/9/2015)
jasona.work (3/9/2015)
SQLRNNR (3/9/2015)
jasona.work (3/7/2015)
Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke it from...
March 10, 2015 at 6:30 am
The answer to that is a bit trickier.
You need to find out which one has the table / indexes you're planning to compress and go from there. One way...
March 9, 2015 at 9:00 am
SQLRNNR (3/9/2015)
jasona.work (3/7/2015)
Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke it from the individual...
March 9, 2015 at 8:49 am
Dan121 (3/9/2015)
1. Since it's TDE enable should I go ahead compress 'Page'? because I will be saving more space on 'page' compression than 'row' compression.
1. Yes, you can compress...
March 9, 2015 at 7:58 am
It's so nice learning both something new, and that your assumption was correct...
I'm going through (again) applying STIGs to servers (gee, a month ago you used the SQL2005 STIG for...
March 7, 2015 at 6:40 am
This is going to be a pretty much "me too" post, but still...
I see nothing against using Express in production (even though I'm not,) if the situation warrants it. ...
February 27, 2015 at 6:42 am
Sigh.
Looked like a great solution, except it generates the same OS error as trying to backup the key in the SSRS Config manager.
I really do think one of the things...
February 20, 2015 at 10:47 am
So I tried tweaking the method that Lowell provided for a one-off, without the SQL DB / Table holding the password for the file. Looks like either I'm typo'ing...
February 20, 2015 at 7:00 am
Lynn Pettis (2/18/2015)
... Mark one off, 9 days on the calendar to go. 9 days on the calendar to go, 9 days to go, ...
Remember to stay safe now, stay...
February 20, 2015 at 6:51 am
Lowell, thanks for the pointer. I hadn't even thought about seeing if there was a way to get the key out with something like Powershell, I'll be giving that...
February 19, 2015 at 5:58 pm
Viewing 15 posts - 1,996 through 2,010 (of 2,756 total)