Browse by Tags

Working with DateTime data types in SQL Server, guidelines and explanations!

Published 26 August 8 2:41 AM | SSQA.net

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it...

Filed under: datetime, sql server, usage, global, datatype, guidelines

How SQL Server manages when a database is created in terms of I/O and disk usage?

Published 29 January 8 5:46 AM | SSQA.net

One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...

Filed under: sql server, performance, management, indexes, windows, i/o, sysmon, disk space, usage, resource, perflib, worker threads, task manager

TSQL cursors vs API cursors - poor cursor usage

Published 27 August 7 8:54 AM | SSQA.net

Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning...

Filed under: application, sql server, performance, usage, cursor, tsql, api, heavy

Is it possible to estimate the space requirement for TEMPDB or factors that are affecting space?

Published 12 July 7 3:16 AM | SSQA.net

No straight answer to say yes you need so and so value to set on TEMPDB for such space requriement. By default i t is difficult to estimate the tempdb space requirement for an application. In general and one of the best practice is to allow 20% more space...

Filed under: sql server, fillfactor, indexes, trace, alerts, trigger, usage, tempdb, allocation, requirement

SQL Server Cursors usage and performance - cursed

Published 19 June 7 9:34 AM | SSQA.net

If you have a requirement to poll through 'n' number of rows then immediately you would think about Cursors in SQL Server. As the solution using any programming language that loops recordsets to build the attendance list that works ok, but really...

Filed under: sql server, performance, databases, dmv, hints, usage, cursor, table

Handling and troubleshooting memory issues in a SQL Server 2005 instance

Published 19 June 7 4:29 AM | SSQA.net

We had a major issue on one of the SQL Server instance with the memory and getting following error message intermittenlty: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. Eventually I was able...

Filed under: sql server, performance, memory, dmv, usage, troubleshoot