We have about 20 dev, stage, and prod SQL Servers and many developers - about a dozen dbs per server. We found the best way to handle permissions on...

I think the view will work if the destination table has extra columns, not fewer.

Format files can be a pain. I would first create a table to match the file structure exactly and use a DTS bulk insert task. It has a...

I noticed that the reads are 4x on the "slower" machine. How do the cluster sizes compare?

If you are not temporary table adverse...

set nocount on

select col1, col2, col3, IDENTITY(int,1,1) as [Index]

from some_table

order by col1, col2, col3

into #temp

set nocount off

select * from #temp

drop table #temp

It is easy...

Without the subquery...

set nocount on

-- setting up base data

declare @a table (a char(2), b char(2), c char(2))

insert into @a values ('a1', 'b2', 'b3')

insert into @a values ('a1', 'b4', 'b5')

insert into...

I would suggest using inner joins. Also, way use an alias if it is the same as the table name?

Would not casting to an int will result in grouping by the 24 hour period from noon to noon, not midnight to midnight?

I suppose you could pick the...

There is also sp_helplogins.

FYI. A bit column takes at least 1 byte. However, SQL Server will store up to 8 bit columns in the same byte. So, 52 state bit...

I never use unicode except when using sp_executesql because the @stmt and @params parameters. I'd not use it then, but it seems to require it.

See "Recovery Interval Option" in BOL and the contained links. The documentation states that a checkpoint does not depend on time, but depends on how many records are in...

We use such a "execute" role also. We also use only role based security so that we can move objects into production with object permissions (no login worries). ...

Some mention of this is at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/SQL/sql0513.asp. There they recommend a fixed size. Also interesting is the MemToLeave question. BOL describes a –g startup option to control the MemToLeave size.

...

I remember reading a post with a comment about a difference between using a proc input parameter versus a local variable in a case like this. For some reason,...