Nope. The dropped the Windows name from Azure. They don't want...

You can't go below the initial size, so you'll have to set that initial size lower. Here is an article from Microsoft that discusses most of the details. There's also...

I did a quick search online and couldn't identify what DCS Service is either.

In general, yes, you can rebuild indexes while the system is in use. You will see some...

So, Eirikur, if you used DATE instead of DATETIME would that also solve the issue? Just asking. I don't know MySQL from MyElbow.

Yep, that's a Performance Monitor counter.

Side note, since you're in SQL Server 2012, I strongly suggest you toss Profiler and go with Extended Events. They're much more light weight, there...

Sean Lange (9/4/2014)

---

Grant Fritchey (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

Roy Ernest (9/4/2014)

---

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we...

Koen Verbeeck (9/4/2014)

---

Roy Ernest (9/4/2014)

---

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we can meet each other...

Yep, fn_trace_gettable is the way to do it.

Also, if you're looking at consuming trace data, I'd suggest getting a copy of the RML Utilities. YOu might have to poke ...

Anyone have a good answer to this question?

Next time, instead of expanding the stuff out, open a query window and look at sys.dm_exec_requests to see what is blocked, blocking, etc., what the wait stats are, that sort...

SimonHolzman (9/4/2014)

---

Grant Fritchey (9/4/2014)

---

[SQL Prompt] does one heck of a lot more than just formatting. Download it & try it out. You can do that for free. Check out the...

Pretty much what Gail says.

Because the optimizer is going to assume you're only returning 1 row ( the lack of statistics), it's going to create an execution plan for returning...

I wrote a short article on backup verification[/url], and, you're right, the only way to be sure your backup is good is to restore it.

Is this SQL Server Express? It could be the instance isn't starting without the connection. Guessing. I've never seen a problem that SSMS, as SSMS, fixes.

Start time, you need to schedule it to run somehow. Generally, I'd use SQL Agent, but you can put anything to work on it that can fire off at a...