Not for me. Everything works as expected.

Which version are you on?

Please post the results of DBCC CHECKDB.

Don't repair!!!

You could damage your database and lose data.

If you're not sure what to do, wait for a reply here before taking action.

Sorry, but I don't see what's wrong. Everything works fine for me.

Can you please clarify what you're getting?

There's an add-in for SSMS that will script out grid results to an excel file in a couple of cliks. You can find it here: http://www.ssmsboost.com

It looks like dbo.region_scorecard is a table or a view.

In that case, you need to provide a predicate to correlate the table dbo.current_year with it:

SELECT ISNULL(dbo.merica.Country, dbo.current_year.[Mega Region]) AS TEST

FROM...

Duplicate post: http://www.sqlservercentral.com/Forums/FindPost1672886.aspx

In SQL Server 2012 you can query a DMV that was absent in 2008 to discover tcp ports:

SELECT *

FROM sys.dm_tcp_listener_states

IPAll sets the port for all IP addresses.

Another method to discover TCP ports is by using netstat:

netstat -abno

You should have some rows returned for sqlservr.exe: note down the PID and...

It really depends what you're after. If you want files in a folder every x minutes, you can use a powershell job.

You need a splitter function: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Let's see if I can rephrase your question:

Question:

I have a table named "sites" with the following definition:

CREATE TABLE sites (

id int PRIMARY KEY,

...

You probably have a "sites" table. If the row is not there, it must have been deleted or it has never been there. If you have a "deleted" attribute on...

With snapshot isolation you mean exactly snapshot isolation or read committed snapshot?

How are you maintaining your indexes? A maintenance plan, a custom stored procedure/job or what?

The latter seems...

You need to give an alias to the whole XML document you're selecting:

SELECT 'A'

FOR XML PATH('')

outputs this:

XML_F52E2B61-18A1-11d1-B105-00805F49916B

-----------------------------------------

A

(1 row(s) affected)

With an alias you get this:

SELECT theDoc = (

SELECT 'A'

FOR...

GilaMonster (3/25/2015)

Annoyingly so, along with the growing accusation "feminist = man...