Viewing 15 posts - 7,411 through 7,425 (of 7,608 total)
While I may agree, I have to play devils advocate, why not cluster on the identity column?
Because the overwhelming majority of queries will specify the datetime.
I wish I had a...
May 31, 2012 at 1:49 pm
As long as you do things in the proper sequence -- change AD first, then use the SQL tools, not the Windows tools, to change the account pwd -- you...
May 31, 2012 at 1:40 pm
*Cluster* the table on the add date/time (rather than on, say, an identity column, which may still be a good idea to have on this table, just don't cluster by...
May 31, 2012 at 1:18 pm
Create a logon trigger, and capture everything you can -- app_name, host_id, host_name (most people don't bother to fake this) and original_login (just in case).
You could of course then also...
May 31, 2012 at 1:15 pm
How about something like this?:
SELECT
/*@date1 = */ last_friday,
/*@date2 = */ DATEADD(DAY, -07, last_friday),
/*@date3 = */ DATEADD(DAY, -14, last_friday),
...
May 31, 2012 at 1:02 pm
Interesting. I used a start-up proc to set the flag, so it was almost immediately on.
May 31, 2012 at 9:34 am
It claims it does, but seems to work only under certain conditions.
May 30, 2012 at 4:40 pm
Not a lot to go on, but I'll take a shot:
SELECT col1, col2
FROM dbo.tablename
GROUP BY col1, col2
HAVING COUNT(DISTINCT col1) = (SELECT COUNT(DISTINCT col1) FROM dbo.tablename)
May 30, 2012 at 4:14 pm
I would think that object name clashes would be a potential concern. If they occurred, resolving those could theoretically involve a LOT of work.
May 30, 2012 at 3:04 pm
Tables with fewer than eight pages can see increased fragmentation when rebuilt, because SQL may spread the table across more extents.
Personally I don't like SQL's mixed extents, but I can't...
May 30, 2012 at 3:01 pm
I can't see the attachment (security issues).
But in general you want to avoid using functions on columns, because it keeps SQL from using indexes (and likely stats) on that column.
For...
May 30, 2012 at 2:57 pm
Sorry, I mis-worded my response.
I didn't see the need for the DealType in the Deals table, since it had its own table. Indeed, since its many-to-one, I don't how...
May 29, 2012 at 2:33 pm
Table 1: Deals (PK DealId)
DealId int
DealTypeId int
Table 2: DealEvents (PK DealId)
DealId int
DealFamilyId (computed persisted '1')
Table 3: DealTypes (PK DealTypeId)
DealTypeId int
DealFamilyId int
I want to create a relationship between Table1 and...
May 29, 2012 at 1:34 pm
Interesting. Thanks for the update.
A little confusing though, not sure what's going on there then. Thought originally it might have just been a mismatched name because of the...
May 29, 2012 at 1:22 pm
Viewing 15 posts - 7,411 through 7,425 (of 7,608 total)