HI,

just to make sure I understand:

You could essentially retrieve that unique record by using just 1 or 2 columns in your WHERE clause.

E.g. SELECT EMP_ID, NAME FROM STAFF_LIST WHERE EMP_ID...

Use Exists (T-SQL)

See: http://msdn.microsoft.com/en-US/library/ms188336(v=SQL.90).aspx

HTH,

B

You may also want to look into Change Data Capture (CDC)

http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx

B

And in SQL Server 2012, you can use FileTables which are very cool.

http://msdn.microsoft.com/en-us/library/ff929144.aspx

http://blogs.msdn.com/b/sqljourney/archive/2012/11/10/how-to-sql-2012-filetable-setup-and-usage.aspx

B

Hi,

to find out last time server was restarted on SQL Server 2008, you can use:

SELECT sqlserver_start_time FROM sys.dm_os_sys_info

Then, to figure when the indexes were last used (i.e. to get an...

since you don't know what the user will throw at the SP, I would suggest you cahnge the data type of the input parameter to be a varchar.

Then, within the...

You should possibly use server side trace (SQL Trace) which has a relatively low impact on performance.

See the following article which compares SQL Trace v Profiler (v nothing):

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx

also this article...

Hi,

Can you add some DDL? also provide some data and then the (simplified) code you use for your query.

As a starter for ten, and only thinking aloud, the issue is...

Hi,

all packages are XML files, meaning you can search through as text files.

I would suggest you download and install a porgram like textpad (http://www.textpad.com which offers a handy 'Search in...

Change Data Capture (CDC) is leveraging the changes applied to the logs as opposed to the actual database, as a result it will "no" impact on your DB performance so...

See if you can drop and recreate the user, maybe there's a disconnect there somewhere?

Have you tried logging into SQL Serevr as that user and run sme DELETE statements in...

Look at full-text indexing and searching:

http://msdn.microsoft.com/en-us/library/ms142571.aspx

B

Look at SSIS (SQL Server Integration Services) which is one of the components of the SQL Server installation.

You should be able to quite easily set up a package which you...

I don't understand your query - would you mind adding some code you have so we can have a wee look at it? that would help tremendously.

Just based on what...

Hi,

Instead of giving additional rights to the user used for the report, you could change the way the SP is run by using EXECUTE AS [UserWithSufficientRights]

In SQL Server 2005 and...