mike 57299 (1/24/2013)

---

The plan is for a website to put in requests in the Queue table and SQL to handle the requests. The called SP would be something like...

It sounds like profiler might be the tool for you.

If you are new to profiler I suggest "Mastering SQL Server Profiler" By Brad McGehee.

http://www.sqlservercentral.com/articles/books/65797/

I vehemently disagree.

I am getting myself confused with some simple maths :crazy:

Answer 1

Coalesce can take more than two parameters, and IsNULL takes exactly two parameters

97%

Answer 5

Coalesce takes exactly two parameters, and IsNULL...

Nice question, thanks

To add, I chose relational and I will stick to that.

Terrible question. To have to make such a fundamental architecture decision with a one sentence spec means this project will be doomed from the start.

Also the explanation mentions the need...

Shock, horror.

Shrink is not recommended. Paul Randall has a great blog post regarding this.

http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/

The method I like to recommend is as follows:Create a new filegroupMove all affected tables and indexes...

Sql Server doesn't care about who is accessing so doesn't expose that info. I think the process worries about two facts. Is anyone accessing the table and is the...

Page is 8Kb, so 5000 pages is 40,000Kb.

SELECT COALESCE(lname + '.' + fname, lname, fname) AS emp_name

FROM employees

The following could help

SELECTt.text,

p.spid

FROMsys.sysprocesses p

CROSS APPLYsys.dm_exec_sql_text(p.sql_handle) t

WHEREt.text LIKE '%##I%'

ANDp.spid <> @@SPID;

Sean Lange (1/22/2013)

---

newdba_sql (1/22/2013)

---

Adding this logic will check the time and if it is not 7AM, it will keep waiting until it is 7Am. How can I add a time...

http://msdn.microsoft.com/en-us/library/ms184325.aspx