Viewing 15 posts - 31 through 45 (of 47 total)
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...
March 29, 2011 at 8:45 am
You could create the structure with
SELECT TOP 0 * INTO <table> FROM <source>
then perform multiple inserts int the new table
March 29, 2011 at 12:46 am
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...
March 28, 2011 at 4:12 pm
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...
March 28, 2011 at 2:35 pm
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,...
March 27, 2011 at 4:43 pm
[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...
March 27, 2011 at 12:41 pm
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>'
...
March 27, 2011 at 11:16 am
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...
March 25, 2011 at 9:56 am
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...
March 25, 2011 at 9:46 am
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...
March 25, 2011 at 9:44 am
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...
March 25, 2011 at 8:35 am
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...
March 18, 2004 at 2:12 am
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...
March 18, 2004 at 2:10 am
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)....
March 12, 2004 at 2:35 am
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.
June 17, 2003 at 1:46 am
Viewing 15 posts - 31 through 45 (of 47 total)