Viewing 15 posts - 9,631 through 9,645 (of 39,769 total)
Eric M Russell (5/21/2015)
Why is including location in server name important for some?
This used to be important for us because we often physically rebooted servers. It was helpful to know...
May 21, 2015 at 7:57 am
phegedusich (5/21/2015)
Why, you...
May 21, 2015 at 7:54 am
call.copse (5/21/2015)
May 21, 2015 at 7:53 am
You may be correct, Hugo. However I think this is a case of there not really being a term available generally and we have different people at MS making up...
May 21, 2015 at 7:51 am
Lovely, isn't it? The deprecated algorithm is the default.
May 21, 2015 at 7:49 am
I'd learn to rebuild reports, trying different queries, and complex structures. Work on windowing functions, and learn to write queries that can easily summarize your data in new ways. Find...
May 20, 2015 at 5:24 pm
Disclosure: I work for Red Gate.
If you want to get Prompt and show it helps, I'd get some queries you normally write, and time the effort in Intellisense to reproduce...
May 20, 2015 at 5:22 pm
I'm late, but a few flaws. One, your questions table doesn't allow for separate surveys. If someone has a new survey they want, or change one, you can't "version" yours,...
May 20, 2015 at 5:10 pm
Shouldn't, but I'd need to test in SQL Azure. AFAIK, this means the user can only create tables in schemas they can control or access. If I create a new...
May 20, 2015 at 1:55 pm
Ah, didn't realize this was Azure SQL Database.
Setuser merely lets me change context. You could use two connections here. One does the granting of permissions as dbo/sa and the other...
May 20, 2015 at 12:00 pm
If you want to practice SQL, I'd suggest you take a few questions on this site, like this one: http://www.sqlservercentral.com/Forums/Topic1687195-3077-1.aspx
Only read the first post and try to solve it. If...
May 20, 2015 at 11:27 am
Your user has permission on the schema, but they don't have rights to create a table. They need CREATE TABLE permissions.
Here's a bit of test code:
CREATE LOGIN Com WITH PASSWORD...
May 20, 2015 at 11:17 am
Jeff Moden (5/19/2015)
I agree but why does one need the extra layer of tSqLt? DelimitedSplit8k even has two different tests built into the header so they won't get lost.
Automation....
May 19, 2015 at 9:06 am
Jeff Moden (5/18/2015)
I did say that most UDFs would never be updated, not all but, let's ask the question.How many UDFs that were already in production have you actually updated?
A...
May 19, 2015 at 9:05 am
Viewing 15 posts - 9,631 through 9,645 (of 39,769 total)