PiMané (2/7/2013)

---

1. It's a mounted logical drive over a physical RAID50 system disk, The \\ is a shared folder on the drive and most databases are "mounted" via UNC and...

PiMané (2/7/2013)

---

1. does the UNC mapping has some overhead since it access via network adapter or is windows smart enough to know the UNC is a local path and uses...

NineIron (2/7/2013)

---

Pardon my ignorance but, I thought I was creating a TVF. I knew that I would be returning more than one value.

The whole point of me creating this...

Here is a working version of your Scalar UDF:

CREATE FUNCTION dbo.ufnCHFPatients

(

@StartDate DATETIME,

@EndDate DATETIME

...

ScottPletcher (2/7/2013)

---

I strongly recommend fully qualifying all table names with the owning schema, typically "dbo" but of course could be different in your specific environment.

For example:

...

from dbo.AbstractData a

inner join dbo.AbsDrgDiagnoses...

worker bee (2/7/2013)

---

worker bee (2/7/2013)

---

opc.three (2/7/2013)

---

dbo is not a Database Role it is a Database User:

You...

ChrisM@Work (2/7/2013)

---

It can be easier to visualise complex filters by switching them into a CROSS APPLY for testing. Shamelessly nicking Orlando's setup, it might look like this;

USE tempdb;

IF OBJECT_ID(N'tempdb..#CLIENT_IDENTIFIER_TYPE') IS...

dbo is not a Database Role it is a Database User:

You gave them dbo?[/url]

We do not have access to your environment. If you would provide test tables (CREATE TABLE statements), test data (INSERT statements) and your expected results based on that test data...

Sorry, forgot the second part of your question:

SELECT name,

is_disabled,

LOGINPROPERTY(name, 'IsLocked') AS is_locked

FROM ...

syslogins is deprecated as of SQL 2005.

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

How about this:

SELECT *

FROM sys.server_principals

WHERE is_disabled =...

It sounds like you are planning to implement something in SSIS already provided in SQL Server. Have you looked into SQL Server Replication?

I have had to deal with that in the past. They were flat files coming from an AS/400. My requirements said to replace NUL with a space (ASCII 32). I...

Recompilation would not take execution time from .05s to 30s unless there are some hellaciously complex queries in the proc. Can you post the code? sanitized to protect the guilty...

For the record it's a CASE expression not a CASE statement.

USE tempdb;

IF OBJECT_ID(N'tempdb..#CLIENT_IDENTIFIER_TYPE') IS NOT NULL

DROP TABLE #CLIENT_IDENTIFIER_TYPE;

GO

CREATE TABLE #CLIENT_IDENTIFIER_TYPE (Code CHAR(3));

INSERT INTO #CLIENT_IDENTIFIER_TYPE

...