Seems that clustered vs heap consideration is more a product of usage rather than size.

I also suspect that any difference in overheads/benefits/etc on small tables would be so minuscule as...

You could also try running DBCC UPDATEUSAGE & then checking stated table sizes again.

When the db's not in use though.

Hi,

How is the date/time being entered for the parameter & how is the time portion being lost?

You can use text, then convert/cast the parameter within the report code.

You'll have to...

And is the database on the default instance or a named one?

dwain.c (11/2/2012)

---

I think interviewers should play Jeopardy with the interviewees.

Answer: ambiguous column

Question: What is the error message you get when you don't sufficiently qualify a column reference with the associated...

Lee Crain (11/1/2012)

---

Question:

If I create a new index to more effectively support a query in a stored procedure, what is the most appropriate action to take (if any action is...

GSquared (11/1/2012)

---

Molecular combinations of metalic ions with hydrogen weakly bonded, such that when combined with bases, they produce a salt, water, and heat. Many of them are caustic when...

Yep the text will display as normal.

If you want underlined & blue, just format the textbox to that.

No problem, hope you get it working as desired!

Just remove the B.Source field from your outer SELECT & GROUP BY

@anthony-2 - you wait a whole 43 minutes and then 2 come along at once! 🙂

You'll need to combine CASE and GROUP BY, something like this:

SELECT CASE WHEN Total >= 0 AND Total < 100 THEN

WHEN Total >= 100 AND Total < 1000 THEN...

Yep, it's done by creating two folder in the root of the reportserver.

You could then provide the URL's direct to the folder to the relevant team, rather than just http://localhost/Reports

You...

Start from the right:

right(fieldname, 10)

If you want to drop the '.' as well:

left(right(fieldname, 10), 9)

Works in vb and SQL.

Not sure that you can do something like that, but you can do URL's to take you to a specified folder, like this:

http://localhost/Reports/Pages/Folder.aspx?ItemPath=%2fteamA

Is that any good to you?