Viewing 15 posts - 391 through 405 (of 573 total)
I started in my current job 6 months ago. I work for a large state department. They have a lot of old MS Access databases and applications. (Over 100 at...
October 3, 2015 at 9:01 am
OK I now see what I did wrong. I guess the default backup mechanism is to append to the backup set. What I really wanted, at least when moving the...
August 15, 2015 at 7:27 am
Perry Whittle (8/10/2015)
please also run a RESTORE HEADERONLY and provide this info so that we may confirm the actual database name the backup references
This one is more interesting. Here's the...
August 15, 2015 at 7:05 am
Perry Whittle (8/10/2015)
As suggested run restore filelistonly against the backup file and post back the results
Here are the results of my doing a RESTORE FILELISTONLY against the backup file:
LogicalNamePhysicalNameTypeFileGroupNameSizeMaxSizeFileIdCreateLSNDropLSNUniqueIdReadOnlyLSNReadWriteLSNBackupSizeInBytesSourceBlockSizeFileGroupIdLogGroupGUIDDifferentialBaseLSNDifferentialBaseGUIDIsReadOnlyIsPresentTDEThumbprint
VideoLibrary_DataC:\Program Files\Microsoft...
August 15, 2015 at 7:01 am
Earlier I said I don't rename things like tables. And that for the most part I oppose it. Well, I've been handled a new project at work, having to take...
June 13, 2015 at 10:37 pm
Steve Jones - SSC Editor (5/24/2015)
Doctor Who 2 (5/24/2015)
How do you do unit tests in T-SQL?
Go to tsqlt.org to get a framework. There are others, like dbunit, tsqlunit, etc., but...
May 24, 2015 at 6:38 pm
David.Poole (5/24/2015)
Doctor Who 2 (5/24/2015)
How do you do unit tests in T-SQL?
Try http://www.red-gate.com/products/sql-development/sql-test/
It is possible to devise your own method of initialising a starting set of data, executing your...
May 24, 2015 at 6:38 pm
I agree with you in principal but sometimes, due to things out of your control, you can't do anything about it. I'm in a situation now where I have identified...
May 24, 2015 at 5:17 pm
I've used SSMS mostly and prefer it. I've not really used SSDT all that much. Can you do things like create SQL Jobs in SSDT?
April 5, 2015 at 1:42 pm
Oh this is a good topic! My favorite example of bad code was from a co-worker I used to work with. She wrote really awful code, and the comments weren't...
March 21, 2015 at 4:24 pm
As a developer I find an MSDN subscription to be essential. I've heard of ReSharper and have seen people using it, but haven't any experience with it. For development I've...
February 19, 2015 at 7:57 am
Thought provoking article, Steve. And I see a lot of people have replied to it. I'd like to comment on the first part of it, but think it would be...
February 14, 2015 at 8:59 am
I agree with you Steve, but sometimes I wonder. Where I worked we had 18 years worth of data which I've maintained and advocated for years, should be analyzed to...
January 31, 2015 at 5:54 pm
In looking at the Mapper function more closely I believe that the @word variable is very likely a NVARCHAR. It's assigned a value from the SUBSTRING function call. I'm still...
January 26, 2015 at 7:37 am
Viewing 15 posts - 391 through 405 (of 573 total)