Viewing 15 posts - 121 through 135 (of 476 total)
Thanks. I went with a Schema with the same name as the remote database (which is, for me, the name of the 3rd party Vendor) and then I restored...
October 31, 2015 at 1:43 am
g.britton (10/30/2015)
Anyway why not add a check constraint to these columns CHECK (col1 <> '')
We weren't trying to enforce NOT EMPTY but rather use EMPTY STRING (from APP) as a...
October 30, 2015 at 8:24 am
Turns out there are nearly 200 files (one per object) that include a reference to remote database - rather more than I had assumed 🙁
My thought is to change all...
October 30, 2015 at 7:17 am
Luis Cazares (10/30/2015)
Just wondering. Why did you go with that path and not the opposite by making all the columns not nullable? I believe that most theorists would prefer...
October 30, 2015 at 7:01 am
Still waiting for the IT guys to "rebuild" the old server for DEV after we migrated from it to a shiny new box for Prod ... its "real soon...
October 30, 2015 at 6:21 am
g.britton (10/30/2015)
Why not just use a check constraint or do you?
Sorry - was that to me?
October 30, 2015 at 4:59 am
You could still restore the FULL (i.e. from a file that you now have locally on the server, so no "transfer time", just "restore time") and then a DIFF and/or...
October 30, 2015 at 4:56 am
Is this a reporting database?
What do the users want? A once-a-day known-time-of-day restore? or a continuously-restoring-but-not-current?
My users think they want "current", but then they realise that "current" includes data in...
October 30, 2015 at 4:39 am
Jeff Moden (10/29/2015)
October 30, 2015 at 4:20 am
seware74 (10/29/2015)
I have always (or at least intended to) treat NULL and empty strings separately in my SQL querying history
This may not be for everyone! and may attract some flack...
October 30, 2015 at 1:28 am
I'm no expert, but my thought is that if you backup the log file only once a day it will be "big" - where "big" is one whole day's worth...
October 30, 2015 at 1:14 am
Back when I wrote my Splitter Function in 2003 I must have read something somewhere about tally tables and mine has 'disallowrowlocks' and 'disallowpagelocks' set. I presume, at the...
October 28, 2015 at 10:25 am
is this just for Database Backups?
If so are regular test restores done (and then checked using DBCC CHECKDB)? Is so then I wouldn't worry. If not I would...
October 28, 2015 at 10:02 am
I use
SUM(CASE WHEN MyColumn IS NULL THEN 0 ELSE 1 END) AS [Count_MyColumn]
rather than
COUNT(MyColumn) AS [Count_MyColumn]
because the latter produces a "Null value eliminated by aggregate" warning (unless using some fancy...
October 28, 2015 at 8:29 am
Andrew Bagley (10/27/2015)
... nor can I use my old Query Analyzer and I need to use SQL Server Management Studio.
I'm still using Query Analyzer (against SQL2008 and SQL1012). Personally...
October 27, 2015 at 11:53 am
Viewing 15 posts - 121 through 135 (of 476 total)