Viewing 15 posts - 181 through 195 (of 1,221 total)
jay-h (1/10/2011)
December 8, 2015 at 9:07 am
david_wendelken (1/28/2011)
Step 1: Do blah...
Step 2: Do blah...blah...
...
Step N: Do blah...blah...blah...
Important! Before doing step 1, ...
That's a basic...
December 8, 2015 at 9:04 am
Gary Varga (12/8/2015)
OCTom (1/10/2011)
I doubt that Twitter improves writing skills. It seems to do the opposite. The nature of Twitter encourages shortcuts and abbreviations that may not aid communication.
Over four...
December 8, 2015 at 9:02 am
AutoClose and AutoShrink are relics from when developers had much more limited resources and were running SQL Server on their local box. These days, they are not considered just...
December 7, 2015 at 9:38 am
One problem that's still on-going, though I think it's diminishing, is that some at the C-level have the perception that IT costs and is not a profit center. It's...
December 2, 2015 at 9:56 am
At a SQL Saturday, I think it was Denver (might have been El Paso), I was introduced to the term RGE: Resume Generating Event. Yeah, I would be very...
December 1, 2015 at 4:57 pm
If you go with an external drive, remember that you'll have to take the database offline or detach it in SSMS for SQL Server to properly close the database files...
December 1, 2015 at 4:35 pm
I would go a bit beyond a reinstall of Windows and SQL Server, at the least do low-level formats of your hard drives and delete partitions. If possible, I...
November 30, 2015 at 9:09 am
I've seen 90% compression on databases before, I would not expect a number like that across all databases all the time. And as Bill Taleda said, don't compress if...
November 25, 2015 at 8:15 am
I called Microsoft to clarify this, Gail is absolutely right. At a previous job we did a server consolidation, so I ordered a single very beefy box with a...
November 24, 2015 at 9:47 am
There's lots of good advice already given that should help. I'd check some add'l things.
1 - Are all the database backups all firing at the same time? If...
November 18, 2015 at 8:37 am
Are you using one copy of the Access FE database? Since you're running across a WAN, you might try putting a copy of the FE on each local server...
November 16, 2015 at 1:58 pm
djj (11/13/2015)Having actually studied engineering (before there were personal computers), I never took a theory class. I have often thought about taking one, but never get around to it.
I...
November 13, 2015 at 1:46 pm
I will say this, though: I think that's a pretty good basic test. Covers the fundamentals of creating and populating tables, relationships, and some moderately complex querying. We...
November 13, 2015 at 11:29 am
I wouldn't suggest them for right now as they tend to dive in to more advanced concepts, but check out the Starways Series[/url] here at SSC. Also take a...
November 12, 2015 at 12:18 pm
Viewing 15 posts - 181 through 195 (of 1,221 total)