Ewan Hampson

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 136 total)

RE: What is your default database set to?

We have always left master as default, as no users have any permissions there, and so far no sysadmin has done any harm; but I see the point, and perhaps...

November 21, 2013 at 4:07 am

#1668066
RE: Barcode 128 generator (using scalar function)

The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ, always starts...

April 8, 2013 at 4:20 am

#1604320
RE: Service Packing

Nothing to do with a log chain: the resource database is specific to the SQL Server Build (and I believe has to keep version in step with the master...

December 14, 2011 at 6:09 am

#1421218
RE: Service Packing

On startup SQL Server reports "the resource database build version" and it seems as important as ever. The main difference in SQL2008 is the location of the resource db,...

December 13, 2011 at 8:57 am

#1420689
RE: BACKUP to share over UNC path is very slow

Lynn Pettis (8/23/2011)
Had a similar issue at a previous employer, turned out the port on one of the switches was set to half-duplex. Just an idea.
That was where my...

August 24, 2011 at 2:17 am

#1372398
RE: System Database - MODEL corrupted

Brandie Tarvin (6/20/2011)
Ewan Hampson (6/20/2011)
SQL Server should have a health warning about system databases and backups
That's what the DBCC commands and the Alert system are for.
No argument with that,...

June 20, 2011 at 7:04 am

#1341161
RE: System Database - MODEL corrupted

Another yes from me. When I lost the log drive (well, Ops mis-partitioned the drives), I hunted out a running Dev copy at the same Build, stopped it and...

June 20, 2011 at 6:13 am

#1341113
RE: System Database - MODEL corrupted

krn045 (6/14/2011)
Started the default instance of SQL Server normally and it started successfully. Then restored model database from recent backup.
...
I have used the data & log files of model database...

June 14, 2011 at 9:44 am

#1338481
RE: System Database - MODEL corrupted
I recovered model when I lost a log drive by
start sqlserver with -T3608
detach model
stop sqlserver

copy good model database files into place (these may be copies from another instance of the...

June 13, 2011 at 3:39 am

RE: In what circumstances are there no other option than to use cursors?

I had a recent example where a developer had created a stats-related Stored Procedure that worked through a decently formed set of joins across tables and Views, applying an update...

February 17, 2011 at 3:12 am

#1288115

RE: SQL2005 SP4 is here

What's with the change since the CTP?

CTP: "Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Vista"

RTM: "Supported Operating Systems:Windows 7;Windows Server 2008;Windows Server 2008 R2;Windows Vista"

The readme seems...

December 20, 2010 at 3:35 am

#1264547

RE: Where a Rose is not a rose…

Unless we can devise special sounds for curly brackets (open and close), semi-colons and maybe an altered intonation for upper-case

Not sure about upper/lower case, but Victor Borge's phonetic punctuation could...

May 21, 2010 at 2:39 am

#1170651

RE: Which is one is good either DETTACH/ATTACH or BACKUP/RESTORE ???????

There are additional points in this discussion.

April 16, 2010 at 4:01 am

#1152663

RE: Green connected icon !

This may be a problem with WMI permissions. See if it makes a difference if you apply the changes detailed in the link.

April 16, 2010 at 3:40 am

#1152657

RE: No More NULL

Good one!

But surely it's more likely we'll see a new "Known Null", to contrast with "Unknown Null"....

April 1, 2010 at 2:48 am

#1143753

Viewing 15 posts - 1 through 15 (of 136 total)

Ewan Hampson

Forum Replies Created

Cookies on SQLServerCentral