Viewing 15 posts - 11,461 through 11,475 (of 49,562 total)
Indexes on a foreign key have nothing to do with referential integrity, the foreign key ensures that. If you're suggesting dropping the foreign keys, don't.
As for whether or not you...
October 2, 2013 at 6:13 am
Table definitions, index definitions and execution plan please. Also the definition of all the functns used in there will help.
Is that distinct really necessary?
October 2, 2013 at 6:04 am
Then you can take any combination of file or filegroup backups and providing you have an unbroken log chain covering all of them, you can restore from multiple file/filegroup backups...
October 2, 2013 at 2:05 am
Normally you'd go a lot further into the design phase before considering physical implementations.
October 2, 2013 at 1:54 am
Warning: Since the DB is in simple recovery, you can take file and file group backups at different times, but you won't be able to restore them (unless all but...
October 2, 2013 at 1:53 am
Depends on IO throughput and database size mostly. A backup to my external drive over USB 2 is not going to be as fast as a backup to an SSD.
October 1, 2013 at 5:55 pm
Grant Fritchey (10/1/2013)
GilaMonster (10/1/2013)
SQLRNNR (10/1/2013)
Paul White (10/1/2013)
GilaMonster (10/1/2013)
And if you want details, come to the WIT lunch on the Thursday.I'll be there. A bit scared, probably, but I'll be there.
Good.
I'll...
October 1, 2013 at 4:37 pm
jasona.work (10/1/2013)
Thanks. I initially held off on doing that, kind of felt like bringing gun to a hammer fight...
Not at all. The mods have that position to keep order...
October 1, 2013 at 1:39 pm
If you only modify the table once a day, the 'disadvantages' are minimal as there aren't that many data modifications. It's when you have a lot of changes that you...
October 1, 2013 at 12:02 pm
SQLRNNR (10/1/2013)
Stand up in the middle as if to make an announcement and commence the "fun"?
Nope. But have something in mind.
October 1, 2013 at 11:12 am
Please note: 8 year old thread.
October 1, 2013 at 10:40 am
SQLRNNR (10/1/2013)
Paul White (10/1/2013)
GilaMonster (10/1/2013)
And if you want details, come to the WIT lunch on the Thursday.I'll be there. A bit scared, probably, but I'll be there.
Good.
I'll probably be late...
October 1, 2013 at 10:37 am
Keith Tate (10/1/2013)
October 1, 2013 at 10:35 am
Cartesian products aren't things that help 😉 This is a cartesian product:
SELECT <stuff> FROM LargeTable1 CROSS JOIN LargeTable2
You get a huge resultset with a number of row equal to the...
October 1, 2013 at 8:22 am
Viewing 15 posts - 11,461 through 11,475 (of 49,562 total)