Some cities here in Arkansas have started using LED stoplights. I can see them much better and the cities are finding much less maintenance and energy costs.

Mine has opened non-maximized for a long time, but I can't figure out how to permanently fix it.

The shortcut will help for now!

Another annoyed QA user

quote from BOL:

Index-->Bit data type-->described

Remarks

Microsoft® SQL Server™ optimizes the storage used for bit columns. If there are 8 or fewer bit columns in a table, the columns are stored as...

select hdr.unqkey, sum(dtl.amt), hdr.hdr_amt_field

from hdr join dtl on

hdr.unqkey = dtl.unqkey

group by hdr.unqkey, hdr.hdr_amt_field

having sum(dtl.amt) hdr_amt_field

If your field has a datatype of varchar, the spaces will be trimmed. It has to be a char field to keep any spaces you want/need.

Take a look at...

dbcc inputbuffer only gives you the first 255 characters of the statement. fn_get_sql will give you all text with these exclusions: "Microsoft® SQL Server™ cannot cache some Transact-SQL statements,...

Brian Knight also wrote a very good paper on Backup and Disaster Recovery. http://www.lumigent.com/go/ud22

When you import, SQL looks at the first 8 rows to determine the datatype, no matter how you have the cell formatted in Excel. If it finds letters 'abcdef'...

1.  Are the data and log files in the same filepath (including drive letter) as they were on the previous server?  If not, you will need to list each file...

I think having dual monitors would help.  I know I am always printing something that I need to reference in another program.  Either notepad or copy/paste won't do what I...

Someone with some smarts might be a better help.  I can't come up with a way to do what they are asking.

This would allow you to sort based on each character.

order by substring(filenum,1,1), substring(filenum,2,1)...

What is the logic behind having 380-41-3a appear before 1110-345-720a3

and 1x4 before 10?

Could you strip out all the...

Do you just need the data moved to the PROD database?  If so, you could truncate the tables and then DTS the data...that would keep the filegroups in PROD and...

Can you backup the database in dev and then restore in prod?  Otherwise, you could script the alter database statements to make the PROD look like DEV, and then import...

One problem I have found in scripting a job, is if there are GO statements in the code, the SP may not generate the job.  It runs in QA because...