In my experience, there is no way to truly prepare for an interview. You know what you know. Cramming probably isn't going to help you much. That...

I've never heard of it referred to as index tearing or index splitting, but I assume he's talking about torn pages and page splitting which are two entirely different things,...

I have no idea why you would want to do this programmatically, but you could do something like this:

SELECT TABLE_NAME, COLUMN_NAME

FROM MyDatabase.Information_schema.Columns

WHERE ORDINAL_POSITION > 2

ORDER BY TABLE_NAME, ORDINAL_POSITION

Greg

Check out this article:

Analyzing Memory Requirements for SQL Server[/url]

Greg

Try this:

SELECT station_id, MAX(time_tag) AS time_lag, sensorname, ed_value

FROM NameOfView

GROUP BY station_id, sensorname, ed_value

Greg

When you use an aggregate function, all non-aggregate data must be included in the GROUP BY.

Greg

First, the six lookup tables shouldn't be an issue with the other three tables as long as the data that you are inserting is in the lookup table.

It looks like...

To get someone to help you further, you have to post your database design. Also, you mentioned that the examples that you have read only insert data into one...

Wow! As of 8AM EST, only one person got this question right. As far as I can tell, out of all the answers only two dates are excluded,...

This will get the number of days between today and the date in the DtContactDate column:

DATEDIFF(dd, DtContactDate, GetDate()) AS NumberOfDays

Greg

Norman,

Try this:

SELECT DISTINCT S.Computername

FROM dbo.tblSoftware S

WHERE S.softwareName = 'App1' AND NOT EXISTS

(SELECT * FROM dbo.tblRegistry R

WHERE R.Regkey IN('RegKey1', 'Regkey2') AND R.Computername = S.Computername)

Greg

I don't think you would want to go with if statements. There are 12 different potential variables in this case, which equals a whole lot of possibilities! I've seen...

I just realized that INT or BIGINT are not large enough to hold a 24 digit number. Maybe DECIMAL(24, 0)?

Couldn't you use SUBSTRING to isolate each individual day, then convert it to an integer. If it's not zero, then the day has availability?

Greg

You could also pass in an XML string and parse it into a temp table or table variable.

Greg