Viewing 15 posts - 46 through 60 (of 109 total)
sql-lover (6/30/2014)
The main advantage of having...
July 1, 2014 at 12:29 am
dhaneenja-755935 (7/1/2014)
It's good Article. I have small Q. if...
July 1, 2014 at 12:27 am
Joe Fuller (6/30/2014)
We changed the index to non-clustered unique and saved ourselves ~220GB.What are the performance problems we may face with this approach?
Hi Joe,
you compare apples with bananas 🙂
In the...
June 30, 2014 at 11:40 pm
sql-lover (6/30/2014)
I would personally stay away of GUI when creating PKs. This is not only because additional locks that the GUI will create, ...
There will be no additional locks when...
June 30, 2014 at 1:47 pm
This article is one of the more worse ones because it is dealing with recommendations which - concerning the original requirements of the database - are nonsence:
"because if you don’t...
June 30, 2014 at 12:14 pm
aaron.bertrand (5/23/2014)
It *is* supported on BI Edition. The docs are merely incorrect and should be updated soon.
+1 - I was of two minds when I answered the question
I choose Enterprise...
May 25, 2014 at 10:15 am
Hallo Hugo,
aaargh - thank you for pointing to that failure.
May 25, 2014 at 10:03 am
Hi Steve,
curious. I've selected "no FK" as one and only option but it gave me "failed" 🙂
However - local temptable are valid in the sessein and they can have indexes...
May 25, 2014 at 5:47 am
lyn.buchanan (3/28/2014)
Why would you point users to the master database = only administrators should be able to access that database.
What a nonsence!
Everybody has access to master database by default.
If the...
April 6, 2014 at 12:28 am
With respect - I know that preparation of a QoTD can be quite tricky and time consuming but this QoTD has the same problem as the last one; it's dealing...
April 2, 2014 at 7:10 am
Good morning Anoo,
Anoo S Pillai (4/1/2014)
@Uwe - Even after going through the question and explanation, Do you still believe that
If the user is member of the db_owner role the...
April 2, 2014 at 12:28 am
Toreador (3/31/2014)Some people need to take a deep breath when getting a question wrong rather than immediately posting an angry response about all the points they've somehow had taken away...
March 31, 2014 at 9:29 am
James Lean (3/31/2014)The script doesn't mention anything about the creation of king_login, so it is implied that this login already exists. In that case, we cannot assume that it...
March 31, 2014 at 3:20 am
Hi,
the question and it's given answer is nonsence. You talk in your "solution" about the sysadmin role!
But in your script you add the user to the db_owner role.
If the user...
March 30, 2014 at 11:04 am
Michael Riemer (1/3/2014)
This looks very similar to the question about a week ago... So a nice easy way to end a friday. 🙂
Unfortunately - yes 🙁
I saw the mentioned QOTD...
January 3, 2014 at 8:29 am
Viewing 15 posts - 46 through 60 (of 109 total)