Viewing 15 posts - 76 through 90 (of 820 total)
Gary I think the process that you are referring to is called "dog fooding". It refers to eating your own dog food. I had some deep experience with...
February 10, 2015 at 9:33 am
You might consider the need to surround the database name in the USE statement with brackets. I just ran CREATE DATABASE [Stop that] and now have a database with...
February 5, 2015 at 10:49 am
Right you are. That asterisk is easier as you don't have to release the shift key. Also since the newer versions of SQL Server have this cool feature...
February 5, 2015 at 10:30 am
I just went and took a look at https://msdn.microsoft.com/en-us/library/ms190283.aspx Right off the bat there is:
XML indexes are not supported in this view. Partitioned tables and indexes are not fully...
February 4, 2015 at 4:59 pm
SQLMaister (2/4/2015)
I am the worlds slowest typist ...
I may have to challenge you to a race then. You can put your ten fingers against my 8. Speaking of...
February 4, 2015 at 4:46 pm
Thanks for the article Ben. I'm sorry that you did not strike gold on your search. Yet you may have turned up nuggets even so.
You got me thinking...
February 4, 2015 at 1:57 pm
Sure the product has gotten better almost version by version. The COUNT function is still a function on a result set rather than a table function, right?
IF I were...
February 4, 2015 at 1:20 pm
I love management studio. It has been one of my favorite tools for a long time now. That said there are some downsides. The fact that SSMS...
February 2, 2015 at 4:25 pm
Thank you for that. You have also confirmed that my idea for a QoD has some validity. I'll try to send you the create table script and please...
February 1, 2015 at 12:32 am
Even when I first wrote this I never anticipated this much debate or this level of vitriol. The point was that COUNT(column_name) may not produce the results that...
January 30, 2015 at 7:04 pm
Yep, I missed the * in the block comments.
January 30, 2015 at 6:08 am
I remember that SQL 2000 trick about stopping the service and deleting the log file. Also found someone stopping the service and making zip of the mdf files as...
January 29, 2015 at 1:59 pm
hau.username (1/28/2015)
I also interested in Tempdb SQL server. Could you share to the tempdb PPTX file, please?
I too would love to see that if it is not a violation of...
January 29, 2015 at 1:42 pm
Great points Steve. I have been amazed at the rapid expanse of storage space as well. We used to be proud of a sector by sector disk backup...
January 29, 2015 at 11:40 am
Well John the other consensus is that a CTE and a derived table in a subquery are about the same thing. The big advantage for me would be readability,...
January 27, 2015 at 2:04 am
Viewing 15 posts - 76 through 90 (of 820 total)