You are not Logged in! Sign In or Register

ViCasting.com

Podcasting Directory

Web	www.vicasting.com

1 Votes Vote
	SQL2005 & C# 3.0
	©
	Podcast Link:

tags: business christian faith ministries of opportunities women women's

Reviewing Job History

Everything a job fail, I used to look at the job history via the GUI. Today, I finally got sick of the stupid ass GUI because when the job history history contains a lot of entry, the damn thing times out or takes FOREVER and you got people breathing down your back asking why [...]

Wed, 03 Dec 2008 22:44:17 +0000

SQL sp_add_jobschedule

I needed to add a schedule to 16 jobs on 16 servers. Again, didn’t feel like clicking thru the gui for all 16 jobs. I ended up using the procedure sp_add_jobschedule. Here’s an example:

Tue, 25 Nov 2008 20:14:24 +0000

updating tables in batches

At work, I have a table that has a gazillion rows. Last night, I had to update a column with a new value and sometime in the night it failed! FAILED. because the log file got fulled. Fine fine, I added another log file, set it to unlimited growth, what do I [...]

Sat, 08 Nov 2008 00:14:09 +0000

c# :: prefix versus postfix increment

I remember the pre and post incrementing function in C++ and Java but yesterday I got a bit of a refresher. So I’ve decided to put it on my blog in case other noobs out there is also looking for the answer. The screenshot pretty much explain it all.

Fri, 31 Oct 2008 19:33:23 +0000

finding foreign keys

When you are attempting to drop an index on a table, you are given the following error: An explicit DROP INDEX is not allowed on index ‘db.tbl_name.index_name’. It is being used for UNIQUE KEY constraint enforcement. This normally means that the index on the table you are trying to modified is being referenced by another table somewhere [...]

Fri, 31 Oct 2008 00:38:49 +0000

general network error

The 16 new servers I am working on is getting a lot of these errors: [Microsoft][ODBC SQL Server Driver][DBNETLIB] General Network error. Check your network documentation ERROR [08S01] [Microsoft][SQL Native Client]Communication link failure System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed [...]

Fri, 24 Oct 2008 04:59:28 +0000

writing WHILE loop with 2 conditions

Thru out the day, I was just hammering out WHILE loops left and right. Everything was going smoothly when looping thru using 1 condition. Cake walk. Then later in the day, I tried to throw in 2 conditions and disaster struck. The damn script never made it into the WHILE loop. [...]

Thu, 23 Oct 2008 08:01:06 +0000

semaphore timeout period has expired

Yesterday, I was deploying some scripts to production. One of the script was to create a database and set its intial size to 50GB for data and log. It created the database alright on the local server but when it attempts to create it on remote servers, it failed with the following error [...]

Tue, 21 Oct 2008 21:11:03 +0000

SQL 2008 Inserts

Remember back in 2000 and 2005 or even older versions, when you were trying to insert multiple rows into a single table? Your code would look something like this insert into [table_name] (column_1, column_2) values (’1′,’2′) insert into (column_1, column_2) values (’3′,’4′) insert into (column_1, column_2) values (’5′,’6′) or insert into [table_name] (column_1, column_2) select ‘1′,’2′ union all select ‘3′,’4′ union all select [...]

Wed, 08 Oct 2008 19:53:54 +0000

Replication :: Check for Replication Errors

Don’t you hate it when you are the last one to know about any type of replication error(s)? I mean, you are the bloody DBA for crying out loud. Shouldn’t you be on top of the game? The attached script will alert you when there are any errors in replication in the last 5 [...]

Wed, 08 Oct 2008 05:40:05 +0000

Comments

There are currently no comments on this podcast.

Contribute: Add a Podcast

New Podcasts

AEMS - METRO BREAKS

Retirement Income Blog via Talkr.com

Annuities via Talkr.com

more new podcasts →

Top Podcasts

A New Holistic Protocol for the Treatment of Herpes and Cold Sores

NBX Sports Action Blog

At OurCoolHouse - Energy Efficient Home design

more top podcasts →

more popular tags →

Add to Delicious