Viewing 15 posts - 151 through 165 (of 189 total)
From MS help for the sys.dm_os_sys_info view, note the bit I have added bold highlight to - WTF!:
virtual_machine_type_desc - nvarchar(60) - Describes the virtual_machine_type column. Not nullable.
ValueDescription:
None - SQL Server...
July 14, 2014 at 4:41 am
I just tried both versions included in the SQL from the article on my local machine which is running SQL 2008 R2 SP2 on 64bit Windows 8.1 (latest updates) and...
July 14, 2014 at 4:33 am
I know the article is this simple to highlight the issue but I assert in real life you would not do this.
If you are doing dynamic SQL then unless you...
July 11, 2014 at 1:18 am
All of this is all well and good until you try to use it like:
Use the...
July 4, 2014 at 3:18 am
We used a very similar code except that we output the schema, routine name and type (e.g. sp, function):
set nocount on
declare @SearchFor varchar (100)
set @SearchFor = 'FieldNameForExample'
select distinct
object_schema_name(SO.Id) as [Schema],
SO.[Name],
case...
April 10, 2014 at 4:13 am
Small note when the question of the day comes through in the newsletter email all I see is:
"For SQL Server 2012 on a stand alone server, Microsoft recommends using domain...
October 25, 2013 at 1:28 am
I found myself agreeing with what you were saying in the editorial until you mentioned Reporting Services - it's so messed up (unless they've fixed it in 2012), it needs...
October 1, 2013 at 1:08 am
Nowhere in my response did I say anything at all about asking for permissions etc...
Obviously asking for sysadmin rights just because it makes life easier you should expect to get...
September 24, 2013 at 3:38 am
Some of what you've said makes perfect sense.
However on the other hand it sounds like you are saying that DBAs have a license to be complete arseholes and that "collaboration...
September 24, 2013 at 1:56 am
I never read the newsletter on anything other than desktop so for me the fixed width is a pain.
If it could have just been the old style but with less...
August 7, 2013 at 1:17 am
I was caught out by words like "the", "to" etc... which I thought would not be counted by near given that common words like those are generally not considered by...
July 25, 2013 at 2:15 am
Basic question designed to seem like a trick?
This applies equally to SQL Server 2005 and 2008 not just 2008R2 and 2012.
March 20, 2013 at 2:09 am
Jeff Moden (11/2/2012)
peter.row (11/2/2012)
November 5, 2012 at 1:21 am
Hey Diego nice article. I understand what you meant about the implied performance concerns and I found Jeff to be very abrasive virtually to the point of being offensive.
Although Jeff...
November 2, 2012 at 2:46 am
When you use SSRS (the product not BIDS bad naming in the article) in a web app that you sell as a product then it has to be Report Builder...
March 27, 2012 at 1:43 am
Viewing 15 posts - 151 through 165 (of 189 total)