Search Results | SQL Server Performance Forums

Fastest DTS method

Thread by: trifunk, May 12, 2004, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi all, I need to create a DTS package that will on a daily basis transfer +- 150000 rows from around 3 tables holding around 18 million (and...

Retrieving windows authentication details

Thread by: trifunk, Nov 6, 2003, 2 replies, in forum: T-SQL Performance Tuning for Developers

If you use windows authentication for you connection details is there a way to obtain the user login name in sql server for that connection eg in the...

Recursive UDF?

Thread by: trifunk, Oct 31, 2003, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi All, Been hitting a bit of a brick wall, I was wondering if it's possible to have a UDF or SP and in it use recursion to navigate a parent/child...

Some form of paging needed

Thread by: trifunk, Oct 15, 2003, 4 replies, in forum: General Developer Questions

Hi all, Maybe someone out there has an easy fix for this, hope so. Basically we have a table with a set of reports on. Each report has a report...

Using * in a query and the query optimiser

Thread by: trifunk, Oct 8, 2003, 3 replies, in forum: T-SQL Performance Tuning for Developers

I've been working on some queries and have found that when queries have the shamefull * operator in them to retrieve all columns instead of the...

Summing up aggregate functions

Thread by: trifunk, Sep 28, 2003, 6 replies, in forum: General Developer Questions

All, I've got a sql statement pretty much like the one below, what I'm trying to do is get the total of all the records returned select...

Rebuild of database falls over

Thread by: trifunk, Jul 21, 2003, 3 replies, in forum: General DBA Questions

Hi all, One of our database crashed last night while rebuilding the indexes in a scheduled job. The exact error was : [Microsoft SQL-DMO (ODBC...

Retrieving row data

Thread by: trifunk, Jun 2, 2003, 3 replies, in forum: General Developer Questions

Hi all, Anyone aware of another method to retrieve an entire row's data into a single field without using the FOR XML clause? We have an audit log...

Difference between bit and tinyint

Thread by: trifunk, May 8, 2003, 3 replies, in forum: General DBA Questions

I'm having a bit of a discussion with my colleagues on this. Does anyone know of any benefit over using a Bit datatype over a Tinyint? They both seem...

Setting NOCOUNT off

Thread by: trifunk, Apr 18, 2003, 5 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I've just read the thread on paging records in stored procedures and noticed that on the 4guysfromrolla link that they SET NOCOUNT ON at the end...

SP works from QA but not from app

Thread by: trifunk, Feb 19, 2003, 7 replies, in forum: T-SQL Performance Tuning for Developers

Hi there, We've got an application that calls a sp, it retrieves 20 rows and then for each row another sp is called from the client app. The query...

Storing Xml

Thread by: trifunk, Dec 13, 2002, 4 replies, in forum: T-SQL Performance Tuning for Developers

Any suggestions on storing xml in the database? I've got an xml document which basically represents a set of questions and their attributes, the...

Database maintenance

Thread by: trifunk, Dec 1, 2002, 8 replies, in forum: Performance Tuning for DBAs

Hi all, I work for a really small company developing software. As it is we're all developers, there's no DBA. I was wondering what kind of...

1 Row datatable or output parameters?

Thread by: trifunk, Nov 28, 2002, 3 replies, in forum: T-SQL Performance Tuning for Developers

I was wondering if anyone could shed some light on what would be faster? I have a query that will always return 1 row which will be on average about...

Inner Join or single queries?

Thread by: trifunk, Nov 20, 2002, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi all, I was wondering if any of you could tell me if there is a major performance improvement in choosing one of the below methods over the other?...