From BOL

NOFORMAT

Specifies that the backup operation preserves the existing media header and backup sets on the media volumes used for this backup operation. This is the default behavior.

FORMAT

Specifies...

You could create the structure with

SELECT TOP 0 * INTO <table> FROM <source>

then perform multiple inserts int the new table

A mac address is a pretty standard thing.

Don't know much about them technically, however looking at this document

http://standards.ieee.org/develop/regauth/tut/macgrp.pdf

I'd be inclined to format toward the standard, using the '-' character instead...

Rewriting as a join (using your logic, which I couldn't get my head around yesterday - trying to get back up to speed with SQL) gives:

With (550000 source rows)

DECLARE @startDate...

Sorry, the query has stumped me...

However taking a step back from the problem makes me wonder whether it can be resolved with SQL, maybe a snapshot table is required,...

[EDIT: Just found this is wrong and gives wrong count on last day; left here as it may give some inspiration. Am working on as output is currently annoying me...

Maybe post the command you're trying to run, it would help people to see what exactly you're trying to do.

ALTER DATABASE <dbname>

MODIFY FILE

(

NAME = '<logicalname>'

...

Storing multiple values in single column <> 'good' 🙂

However, there was an elegant bit of code on this site that I came across monday which may help.

Adapt for your...

p.stevens76 (3/25/2011)

I've tried the union route which should now return an extra row of data from my sample table but I've never tried doing a union on queries before...

Further to the reference table see if this meets your needs.

Note: The AllowableCombinations would require maintaining, however no more code would have to be written.

Note: I'd also suggest making Diag...

The simplest solution would to perform a union on three separate queries so long as you only have a handful of criteria.

If criteria are likely to expand then this wouldt...

Defragging can give a performance benefit if your drives are badly defragmented, but requires the databases to be offline.

If you've got a SAN environment, large caching helps to alleviate the

affects...

If Access isn't releasing its connection then there is a problem with Access.

Many issues to look at here (hopefully some may be of help):

1. If you don't care how long...

If the databases already exist, take a sample of how many records appear in a timeframe of say, a year for each table (get the year with the most records)....

It's a recognised bug, shut performance monitor on the server console before restarting the sql services.

Will help avoid a call to PSS, if you've not already done so.