Better would be to have a timeout on the application side. If you kill the connections, you could see data loss.

But, you can look at sys.dm_exec_connections to see the connection...

Exactly the kind of information it's always best to go directly to the source for. This is Microsoft's documentation on the OS versions required for SQL Server 2014. The two...

I post the query into the message box. Then, over on the left side of the screen you'll see all the IFCode Shortcuts. Highlight your query and click on the...

Excellent points Eirikur. I agree. I do like the checklist for the common problems, using the wrong data type, functions on columns, stuff like that. But even those, tell people...

So, the other problem is, you're going after sys.dm_exec_query_stats. That records the statements. That's what it's for. If you only want to see "objects," and by that definition we mean...

Excellent! Couldn't agree more.

The clue is the start and end offset. They are statements in a single batch. The queries in a batch are stored seperately, but the batch, especially in the sql...

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do it is COUNT. Everything I...

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries, you can just add them in...

You're describing Change Data Capture.

Since no one else pointed it out, I sure will:

WHERE (dbo.CLI.CLITYPE LIKE '%A%') AND (dbo.SVAC.PROGNO LIKE '%286%' OR

dbo.SVAC.PROGNO LIKE '%288%' OR

dbo.SVAC.PROGNO LIKE '%289%')

That is going to lead to some...

No. Unable to connect to server suggests that you're trying to connect to the wrong server, are running the Upgrade Advisor from a login that doesn't have permission to the...

There's not enough here. These are part of a greater process. That other process has other statements. You need to determine the order in which these statements are occurring. This...

There are simple references for normalization all over the place online. Just do a search and you'll find one.

As to a guide on database design, I'm not aware of a...

Brandie Tarvin (4/10/2015)

Luis Cazares (4/10/2015)

Grant Fritchey (4/10/2015)

Brandie Tarvin (4/10/2015)

Not that I've ever...