Viewing 15 posts - 2,386 through 2,400 (of 6,035 total)
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
Time and again, good employees have walked away from good jobs in search of another job that will somehow make them happy. However, in many cases it's their life, not...
August 11, 2016 at 6:40 am
When you're sailing around the Carribian, searching for gold and dodging arrows, it's probably easy to lose track of which day of the week it is.
August 11, 2016 at 6:15 am
brad.pears (8/10/2016)
August 10, 2016 at 2:59 pm
Viewing 15 posts - 2,386 through 2,400 (of 6,035 total)