sql server Archives - Dirk Strauss

The Daily Six Pack: August 17, 2015

On 17 August, 2015 01:15:48, in The Daily Six Pack, by Dirk Strauss
Identify Locked SQL Table
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

Feature link: Identify Locked SQL Table
Other

View my Flipboard Magazine.

Even More
For more excellent content, have a look at these great sites

Morning Dew

Connecting SQL Fails? Did You Hibernate Your PC?

On 6 May, 2015 00:15:37, in Programming, by Dirk Strauss

Connecting SQL Fails after waking your PC from hibernation? Well then the solution might be a really easy one. Here is a quick post on fixing this annoying issue.

Continue reading »

The Daily Six Pack: December 09, 2014

On 9 December, 2014 06:00:01, in The Daily Six Pack, by Dirk Strauss
Einstein Regarding Haters
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

Feature link: Einstein Regarding Haters
Other
Even More
Extra
For more excellent content, have a look at these great sites

GeekLift

The Daily Six Pack: July 30, 2014

On 30 July, 2014 08:37:16, in The Daily Six Pack, by Dirk Strauss
Swift Introduction
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

Feature link: Swift Introduction Part 2
Other
Even More
For more excellent content, have a look at these great sites

GeekLift

Tagged with:  

Execute Script Error Resolved In SQL Server Management Studio

On 27 February, 2014 01:00:45, in SQL, by Dirk Strauss

Execute Script Error – Imagine my surprise when I tried executing a rather large SQL script (255 Mb) and received an error telling me that there was ‘Insufficient memory to continue the execution of the program. (mscorlib)’. You might be wondering why I would even have such a large script to begin with. Well I had to import data from a file that I didn’t have access to any more, so I decided to script the table contents from the live database and import into my dev database for testing. Trying to run the query produced the error and I had to find an alternative way to get the data into my table.

Continue reading »

If there is one thing that I always had a pet peeve with, was the table designer column data type default in SQL Server Management Studio. You have no option (that I am aware of) to change the default column data type when creating a new data table in table designer. SQL Server Management Studio decides that using ‘nchar’ is the way to go. Well if you want to make your columns another data type, you need to manually select the default value and change it to the data type you want. I wanted to find a way to change that default. Turns out that there is an easy way to accomplish this.

Continue reading »