Viewing 15 posts - 556 through 570 (of 1,158 total)
HowardW (2/9/2012)
MysteryJimbo (2/9/2012)
February 9, 2012 at 6:54 am
L' Eomot Inversé (2/8/2012)
Koen Verbeeck (2/7/2012)
What's to like in warm beer? 🙂
Depends on the beer.
There are actually some beers that taste good, so you can drink them without cooling them...
February 9, 2012 at 4:41 am
Create a variable called server (or similar) and a variable called database. Give them a default value so you can run the package as debugged.
Modify your database connection to...
February 8, 2012 at 9:58 am
Does this database exist under system databases? Is this server a distributor?
The distribution database is the default name of the transient system data used in replication and will only...
February 8, 2012 at 5:38 am
I've previously used a dns entry to point at a SQL server. All I needed to do after that was change dns between machines.
Changing the name of a server...
February 8, 2012 at 5:37 am
Steve Jones - SSC Editor (2/7/2012)
george sibbald (2/7/2012)
February 7, 2012 at 3:44 pm
PAH-440118 (2/7/2012)
When we go to SQL 2K8 compression is built in. Do the like of LiteSpeed give any benefits over this?
My experience with the compressions ratios suggest litespeed compression is...
February 7, 2012 at 11:48 am
PAH-440118 (2/7/2012)
February 7, 2012 at 11:47 am
Bru Medishetty (2/7/2012)
PAH-440118 (2/7/2012)
Do the like of LiteSpeed give any benefits over this?
If I am not wrong, LiteSpeed has an option to restore a single object from a backup,...
February 7, 2012 at 11:46 am
rajiv.varma (2/7/2012)
1) If I add a secondary file group and mark it as default, will any of my queries using the primary file group fail?
No, this is transparent for intents...
February 7, 2012 at 9:40 am
SQL server does have instant file initialisation. It's just not on by default.
It can be enabled by giving the service account volume tasks permission in the security policy
February 7, 2012 at 9:28 am
One of my databases space usage goes up by 20GB on a weekend. I always presize it for the week as growth varies slightly but always gets used eventually.
Presizing...
February 7, 2012 at 7:57 am
PAH-440118 (2/7/2012)
Currently one of our main production db's (SQL 2K5 soon to move to 2K8) is 1.7Tb and take around 6.5hrs to backup. As I currently have no environment to...
February 7, 2012 at 7:49 am
Wo there.
Approx 40 million rows in each table and a query with no WHERE clause. Why are you duplicating all of this data by inserting it into another table?
Whats...
February 7, 2012 at 7:44 am
Viewing 15 posts - 556 through 570 (of 1,158 total)