Unless you modified the script which profiler generated, it will have a file size of 5MB and no rollover set. That means as soon as the trace file reaches 5MB,...

Table definitions, index definitions and execution plan please.

No.

Restart SQL.

There isn't a process at the OS level to kill (and if you have the idea of killing threads within SQL from the OS, that'll likely crash the SQL...

Steve, slight problem with the new forum name:

It makes the prefix of the email subject way too long

You need to grant the SQL Server service account (the account SQL runs under) full control of all data and log files and all folders which contain data and log...

Still not understanding the problem, could you explain in more detail?

If it's file permissions, then grant the needed permissions or ask your administrator to help you.

That one will work. Just remove the reference to sys.procedures and instead cross apply to sys.dm_exec_sql_text for the procedure's definition.

What do you mean 'unlock a database'? What are you trying to do?

No, the optimiser's the same in all the editions. Express won't run queries in parallel (it's limited to one CPU) for example, standard has memory limits, etc.

The display of the...

Brent Ozar (4/23/2014)

---

A lot of the fun of the MCM lab was that the questions had surprising catches. The questions and answers alone weren't enough - the lab environment itself...

Perry Whittle (4/23/2014)

---

in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B. Whenever the...

Ok, but unless the *majority* of the values are two or one character, you won't be saving any space...

tfendt (4/22/2014)

---

My understanding is the total time spent waiting is counted across all connections. So if I have 100 users and they all had to wait 1ms, sql server would...

But you don't need to right trim everywhere, maybe on display but SQL ignores trailing spaces when doing comparisons.

Yes, you can do validation in a trigger, but you're losing out...