j-1064772 (4/29/2016)

---

Sioban Krzywicki (4/28/2016)

---

I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's...

SQL!$@w$0ME (4/29/2016)

---

Hello guys,

I can't connect to a named instance(TCP/IP) through VPN connection. But I can connect to the default instance(TCP/IP) [highlight="#ffff11"]on the same server[/highlight] through VPN.

The named instance is...

it's not a one line fix; performance and query tuning and analysis, a have entire books written on the subject.

in general, my knee jerk reaction would be to update statistics...

just the drops scripts are pretty easy, you can just build the statements from sysjobs;

select

'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name + ''')

EXEC...

Sioban Krzywicki (4/28/2016)

---

I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all...

Sioban I'm with you here!

I try like crazy to make everyone replace reserved words, as well as fixing misspelled columns i inherited.

I have a column ProvdierType that makes me crazy,...

CTE's would work, as well as subqueries(same thing,really , just different format.

here's my version of your post as CTE's:

DECLARE @personID INT = 123999;

WITH ELDASummary

AS (SELECT...

there's no upgrade path for Express to non express versions; instead you need to backup all the databases, script out your logins, as well as anything server related...certificates, linked servers,...

a trigger has a COLUMNS_UPDATED integer value which represents a bitmask for the columns that were mentioned in the update, but it does not tell you if the value changed...

is this on a cluster, where it might be failing over or toggling to the other node?

is it possible someone is downing the server for maintenance?

did you check the...

i think it's integer division. SQL maintains the datatype, and the avg is truncated to a integer.

change the datatype of the column from int to decimal(19,4) and you get 2.5

Declare...

if the table has an implicit or explicit ordering, like an identity() column, or a CREATEDDATE datetime column, you can compare old to new in a set based operation, by...

SQL Server Import and Export Wizard

https://msdn.microsoft.com/en-us/library/ms141209.aspx

well i dug a little deeper in my old parser utility.

i expected the tables to be identified as TOKEN_TABLE, but they end up being TOKEN_ID instead; i guess with a...

INNER JOIN (

SELECT Top 1

that will return one , single row, not one row per policy number, right?

so the other table is limited to match one row as...