Viewing 15 posts - 1 through 15 (of 17 total)
Maybe take a look at http://www.databasetestdata.com
It is free, and not limited to just a few rows (like many other demos of for-fee generators).
Chris
April 20, 2017 at 5:54 am
https://msdn.microsoft.com/en-us/library/ms190763.aspx
suggests that you can set a global default (but the default will be overridden by an explicit SET in a query).
Chris
July 1, 2016 at 3:09 am
Most example candidates begin:
[font="Courier New"]<space><int><space><int><space><YYYYMMDD><space><MM/DD/YYYY><space><YYYYMMDD><space><GLOB><space>[/font]
If this were ALWAYS the case, you could look for 'GLOB', count back six <space>, and you have found the split-point.
You might even check that the...
June 4, 2016 at 3:13 am
-- step 3: do rest of html formatting -- this is not working for me.. If I can get the corrected format for HTML, then I think I am done....
June 3, 2016 at 2:14 am
Ken McKelvey (8/19/2014)
SELECT *
FROM YourTable
WHERE SnapshotDate > @from AND SnapshotDate < @to
OR (SnapshotDate = @from AND hourkey > 2)
OR (SnapshotDate = @to AND @to < 21)
Typo in the last OR:
OR...
August 19, 2014 at 7:53 am
I/O frozen & resumed could be Shadow Copy.
Look for snapshots:
USE msdb
GO
SELECT server_name, database_name, backup_start_date
FROM backupset
WHERE is_snapshot = 1;
Maybe your hosting service is backing-up the entire VM?
If you are taking diffs,...
August 2, 2014 at 2:45 am
murrabp
"The website to which you refer is either incorrect in it's APR calculation or I am applying it incorrectly"
Not necessarily!
For a brief overview of divergences between various "official" APR calcuations,...
July 3, 2014 at 8:48 am
External backup mechanisms will use VSS to handle the locked SQL-Server DB files: since you are getting external backups, VSS is being used.
The VSS effort is "seen" as a Full...
March 19, 2014 at 10:31 am
Hi Gail,
"The backup started after the commands started, so as long as they finish before the backup finishes, they will be in the restored database" sort-of suggests that the start-time...
December 31, 2013 at 2:47 am
IDENTITY_INSERT won't fix the issue of duplicate id coming from different offices.
If IDENTITY_INSERT allowed you to introduce a duplicate id despite the PK constraint, what happens to related rows in...
March 11, 2013 at 11:53 am
Seed the autoincrement differently for each office?
e.g.
1 for head office
100,000,001 for 1st branch
200,000,001 for 2nd branch
....
2,000,000,001 for 20th branch
if you need more rows/branches than can be accomodated with int (including...
March 10, 2013 at 5:02 am
This might not be the best place for your question - this is an SQL-Server site.
Have you tried pushing your dates-as-string into #mm/dd/yyyy# format?
Mock-ISO formats also work: #yyyy-mm-dd# or #yyyy-mm-dd...
March 9, 2013 at 11:34 am
Consider this stuff IMPLEMENTED before next closing.
Every year we have two folk locked in a room for days, reading thousands of numbers at each other trying to track down why...
January 11, 2013 at 12:23 pm
hmmmmm!
Today's (28th May) newsletter works OK with my webmail!
Did something change overnight in the format of your newsletter?
The newsletter of 25th May works fine when forwarded to my Win7/OL2007 machine...
May 28, 2010 at 4:12 am
The direct link (posted by <I wish I could see when I'm replying> above) works fine.
I'll let you know what turns up in the forwarded mails to the Win7/OL machine.
It...
May 27, 2010 at 11:58 am
Viewing 15 posts - 1 through 15 (of 17 total)