Viewing 15 posts - 2,386 through 2,400 (of 6,038 total)
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
August 16, 2016 at 8:47 am
It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number of projects, more like an analyst role, wihout...
August 16, 2016 at 7:14 am
The engineering DNA of the SQL Server database engine is optimized for online transaction processing, not bulk loading or aggregation.
You may also want to consider BCP-ing the 600 GB...
August 16, 2016 at 7:03 am
When SQL Server constructs an execution plan, it takes a lot of things into consideration and it attempts to come up with a good balance. If it is known that...
August 16, 2016 at 6:49 am
Ed Wagner (8/15/2016)
Eric M Russell (8/15/2016)
August 15, 2016 at 1:52 pm
Northwind is obsolete. It was replaced by AdventureWorks, which was replaced by Contoso.
Here is the CodePlex site where Northwind is maintained. It hasn't been updated since release 2008, but you...
August 15, 2016 at 10:48 am
.. The explosion in aircraft innovation came when a variety of private companies began to build and fly aircraft. ..
Don't say "explosion" in the context of manned rockets. Instead say...
August 15, 2016 at 9:17 am
When it comes to revceiving data feeds from external clients or 3rd party providers, it's best when an auto-certification process breaks the file transfer when the file isn't formatted properly....
August 15, 2016 at 9:12 am
There is no secret sauce in SSIS that allows you to insert a table without transaction logging.
The following article provides a good explanation of minimal logging and summary of the...
August 12, 2016 at 9:45 am
HappyGeek (8/11/2016)
Iwas Bornready (7/25/2016)
Yet Another DBA (7/22/2016)
Time to leave?Hmm, with some companies its the day after I started.
That's sad you didn't know that before you started.
So how exactly do you...
August 12, 2016 at 9:31 am
Table Partitioning, TDE, and page compression can all work in conjunction.
August 12, 2016 at 9:19 am
Victor Kirkpatrick (8/12/2016)
Thanks Andy, good info. Pardon my ignorance, but what does "C level audience" and "C suite" mean? Client/Customer?
Chief Executive Officer, Chief Information Officer, Chief Happyness Officer, etc.
We're all...
August 12, 2016 at 9:11 am
Snargables (8/11/2016)
What would be the best way to do this? The db is in simple mode. i need a copy format that doesnt write to trans log.Ideas?
Simple Recovery model itself...
August 12, 2016 at 9:02 am
I wish that Microsoft would invest some in upgrading the SSMS database diagramming tool. Deprecating the functionality from recent versions of Visio was also an odd move, since ERD diagramming...
August 11, 2016 at 11:57 am
Gary Varga (8/11/2016)
...My keyboard often remains deathly silent as I attend yet another meeting. [sigh] :crying:
That's one problem with being the DBA, we're obliged to sit in on too many...
August 11, 2016 at 6:45 am
Viewing 15 posts - 2,386 through 2,400 (of 6,038 total)