Pat_B (1/24/2009)

---

I have a column called [created date ] that is of the datetime data type. This column has the date and time stored in UTC. About 13000 records are...

Anything’s possible, but a DBA job is usually for someone with significant industry experience as a developer, administrator, or both, and usually a BS\BA degree. It’s more of a...

You really need to look at the type of paging. There are many types of paging that have nothing to do with the page file. They can just...

Back to the original question, I would speculate there were a lot of possible correct answers, and what the question was really about was probing your level of understanding of...

The only really valid test is with production levels of data in the tables.

I have used temp tables for things like this when it prevented SQL Server from choosing a...

Lynn Pettis (1/21/2009)

---

Garadin (1/21/2009)

---

Jeff Moden (1/21/2009)

---

Garadin (1/20/2009)

---

Michael Valentine Jones (1/20/2009)

---

In the end, does the reason why really matter?

We had a meeting where we objected to a project as complete waste...

This code generates 16 character, unique strings increasing in value. There may be gaps in the sequence.

See my last post for a link to the code for F_NUMERIC_TO_BASE_N .

declare...

Using the function on the link below, this code will generate a random string that is highly likely to be unique.

However, the nature of random numbers is that they they...

select top 4

a.*

from

(...query to select top 10, whatever that is...) a

order by

newid()

In the end, does the reason why really matter?

We had a meeting where we objected to a project as complete waste time and money, and were trying to talk our...

I had requirements for a datamart application where we had to produce many reports with rankings within various hierarchies. Example: product sales ranked within departments, product categories, regions, stores,...

Assuming you have a calendar table with all dates in it:

select

NextBusinessDay = min(a.MyDate)

from

MyDateTable a

where

a.MyDate > @MyStartDateand

a.MyDayOfWeek not in ('Saturday','Sunday')and

a.MyHolidayIndicator <> 1

If you need to load a calendar table, this code...

There are many options, but here are a few.

You can use the Computer Management utility to check if the service is running.

You can use the SC command line utility from...

J (1/15/2009)

---

Michael Valentine Jones

Create database roles for different types of user access, assign database and object permissions to database roles only, and then add individual users to...

Create database roles for different types of user access, assign database and object permissions to database roles only, and then add individual users to the correct database roles.