Viewing 15 posts - 7,216 through 7,230 (of 7,608 total)
patrickmcginnis59 (9/13/2012)
The approach of applications having their own databases is probably the norm
Perhaps, perhaps not. But is that a good way to do it, regardless of how common it...
September 13, 2012 at 4:49 pm
You can use this to check for files that still exist in a given filegroup(s):
SELECT
FILEGROUP_NAME(a.data_space_id) AS File_Group,
OBJECT_NAME(p.object_id) AS Table_Name,
...
September 13, 2012 at 4:40 pm
SELECT
Item,
MAX(CASE WHEN [Group ID] = @group1 THEN Permission ELSE '' END) AS Group1_Permission,
MAX(CASE WHEN [Group ID] =...
September 13, 2012 at 4:16 pm
Lynn Pettis (9/13/2012)
ScottPletcher (9/13/2012)
but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone...
September 13, 2012 at 3:12 pm
but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone decides they need...
September 13, 2012 at 2:42 pm
A company I worked for produces clothing catalogues. Each catalogue has a 2 character reference. They produce about 130 catalogues/adverts a year, but not all letters get used...
September 13, 2012 at 2:39 pm
Eugene Elutin (9/12/2012)
Greg Snidow (9/12/2012)
Jeff Moden (9/12/2012)
Greg Snidow (9/11/2012)
The 'id' column in every table was a bit annoying to work with.
It's even more annoying when you need it and it's...
September 13, 2012 at 1:39 pm
Sean Lange (9/13/2012)
ChrisM@Work (9/13/2012)
ScottPletcher (9/12/2012)
It would have to be THE ONLY WAY POSSIBLE...
September 13, 2012 at 10:38 am
I think maybe you can save a little overhead by checking for the known difference expected in the result, naturally including the next-higher value as well to allow for "borrowing"....
September 12, 2012 at 5:09 pm
1. What does the GroupID column in profiler mean ?
GroupID as classified by the Resource Governor for the current session.
September 12, 2012 at 4:42 pm
There is NO case where I would ever want to use a GUID as a clustered key column.
It would have to be THE ONLY WAY POSSIBLE for me to consider...
September 12, 2012 at 4:31 pm
GilaMonster (9/12/2012)
Well, both of those statements are incorrect, so probably better to just ignore them...
Quite true.
September 12, 2012 at 4:27 pm
Lynn Pettis (9/11/2012)
Lynn's method:
Elapsed Time (ms) 8276
ScottPletcher's first method:
Warning: Null value is eliminated by an aggregate or other SET operation.
Elapsed Time...
September 11, 2012 at 1:06 pm
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as...
September 10, 2012 at 5:09 pm
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I...
September 10, 2012 at 4:28 pm
Viewing 15 posts - 7,216 through 7,230 (of 7,608 total)