If there is someone doing a DBA interview that doesn’t have the technical understanding to be able to weed out a bogus DBA, then they probably shouldn’t be in their...

Marker (12/23/2008)

---

Ok, I do want to create a custom script to switch the db to bulk_logged during index rebuilds. I started creating a script and if I should be...

The minimum amount of transaction log space required will be at least as large as the largest table in the database. This is because re-indexing rebuilds each table in...

Did you have a question that you wanted to ask?

I think there should be a separate SQL Haiku forum where both questions and answers must be posted in the form of a Haiku.

If you want help, you should post your sql in the message in between code tags.

Most people (including me) will not open a file posted on the forum because it...

The code you posted isn't even in valid SQL syntax.

Please supply your actual query code, table definitions, sample data, and your expected output with the sample data.

Here is another approach on the link below. Function F_TABLE_DATE is a multistatement table-valued function that returns a table containing a variety of attributes of all dates from @FIRST_DATE...

You will have to open a cursor on the inserted table and execute the procedure once for each row returned by the cursor.

This looks like something that would be better...

Add an ORDER BY clause to the SELECT statement that is calling the function.

declare @t table (pk int not null primary key identity, dat varchar(10))

insert into @t (dat)

select '1' union all select '001' union all select '11' union all

select '100' union all...

This is not an easy problem to generalize.

Take this name for example: “Carl von Clausewitz”. Unless the procedure knows the conventions, how does it identify that the last name...

I’m going to make the assumption that what you mean by “Outsourcing” is Offshore Outsourcing.

A lot of senior management types see IT as a necessary evil at best, and really...

800 MB is a very small database. Did you actually mean 800 GB? ...

gan (11/27/2008)

---

Michael Valentine Jones (11/25/2008)

---

In that case, let me jump in. 😀

There are many opinions of this subject, but I...