Viewing 15 posts - 16,741 through 16,755 (of 59,067 total)
Having 3 different databases has other advantages than those already mentioned. The BIG ones are that your "IMPORT" and "STAGING" databases likely don't need to be backed up because...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 4:36 pm
djj (9/22/2016)
Y.B. (9/22/2016)
djj (9/22/2016)
Revenant (9/22/2016)
Kaye Cahs (9/22/2016)
eccentricDBA (9/22/2016)
Ray K (9/21/2016)
Ed Wagner (9/21/2016)
Grumpy DBA (9/21/2016)
Ed Wagner (9/20/2016)
Grumpy DBA (9/20/2016)
Ed Wagner (9/20/2016)
ButterFace
Palm
Rosey
Garden
Madison (Square)
Zingers (Dolly Madison Bakery)
Snoballs ®
Calories
Counting
Down
Out
Delivery
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 12:44 pm
Credits to Navy beans bet on it being a "Startup Proc". See the following for more details...
https://www.google.com/?gws_rd=ssl#q=startup+procs+sql+server
{edit} Apologies... didn't scroll down far enough. Didn't see Richard's post nor...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 12:29 pm
I'd be in deep Kimchie if I deleted some of my empty tables because they're used to prop up some very necessary "Instead of" triggers on a View that we...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 12:28 pm
I don't use SSIS so I can't help much there but... how would setting up Replication (not a favorite of mine, BTW) for these 21 tables compare or is that...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 12:10 pm
Rod at work (9/22/2016)
Jeff Moden (9/21/2016)
djackson 22568 (9/21/2016)
Jeff Moden (9/21/2016)
Steve Jones - SSC Editor (9/21/2016)
Jeff Moden (9/19/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 10:07 am
david.leyden (9/21/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 7:40 am
Sean Redmond (9/22/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 7:32 am
Terry B-214928 (9/22/2016)
Backups are on a separate server.Thanks
With that out of the way, then I agree... you probably don't need to put TempDB on a separate drive.
I will also advise...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 7:01 am
BrainDonor (9/22/2016)
chatwithgeorgelucas (9/22/2016)
Hey Jeff, Can you please provide me the link. Thanks in advance.
In case you've misunderstood Jeff's humour -
Using either Yahoo, Google or Bing search for "SQL Tutorial"...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 6:05 am
joeroshan (9/22/2016)
Jeff Moden (9/21/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2016 at 5:48 am
Minnu (9/21/2016)
Restoring SQL Server database from one server to another.
Actual Database size is: 14.3 GB
But while restoring getting below error.
The database required 127533776896 additional free bytes, while only 47082643456...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 21, 2016 at 4:14 pm
Terry B-214928 (9/21/2016)
The server has...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 21, 2016 at 4:09 pm
waxb18 (9/21/2016)
I've received a flat file which needs to processed into a SQL table, the only problem being that the file has no column delimiters hence when imported...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 21, 2016 at 3:04 pm
You don't need to use XP_CmdShell and BCP to import unless you're working around a privs issue.
And, to skip the headers, use the "First Row" option.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 21, 2016 at 2:56 pm
Viewing 15 posts - 16,741 through 16,755 (of 59,067 total)