Search Results | SQL Server Performance Forums

Neverfail for Microsoft SQL Server !!

Thread by: deepakontheweb, Apr 6, 2007, 1 replies, in forum: Third Party Tools

Just curious to know more about Neverfail for Microsoft SQL Server, is there somebody already using it for Disaster Recovery & High Avilability...

Surfray : Speed Index

Thread by: deepakontheweb, Jan 29, 2007, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Just Curious because it look intresting to have 1800 times faster index search, has somebody noticed and used speed index described in below links...

What prevents DBAs from migrating to SQL 2005

Thread by: deepakontheweb, Feb 19, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

I read an interesting post on Microsoft.private.mvp.sqlserver from Hilary Cotter, and would like to know views and opinion from all of you.....

Facts :-)

Thread by: deepakontheweb, Jul 28, 2005, 10 replies, in forum: The Lighter Side of Being a DBA

Coca-Cola was originally green. The most common name in the world is Mohammed. The name of all the continents end with...

xp_sendmail: failed with mail error 0x80004005

Thread by: deepakontheweb, Jul 18, 2005, 16 replies, in forum: General DBA Questions

I have recently changed SQL Logon domain user expample: from aax1 to aax2.. Now aax2 is being used for running sql and agent services. There used...

Before Deadlock/ Blocking... ??

Thread by: deepakontheweb, Jun 30, 2005, 9 replies, in forum: General DBA Questions

There is a table, T1, with one row in it. The row has an ID=1. One user has a session S1 in which he begins a transaction to insert a row with the...

CSV file using BCP

Thread by: deepakontheweb, Jun 6, 2005, 2 replies, in forum: General Developer Questions

Hi All, I am creating a CSV file using BCP for a table. EXEC master..xp_cmdshell 'bcp "select * from Authors" queryout C:Author.csv -c -t","...

BUILTIN/Administrators on cluster

Thread by: deepakontheweb, Apr 26, 2005, 2 replies, in forum: SQL Server Clustering

From SQL BOL : - You should not remove the BUILTIN/Administrators account from SQL Server. The IsAlive thread runs under the context of the cluster...

what i m missing in Restore

Thread by: deepakontheweb, Apr 25, 2005, 2 replies, in forum: General DBA Questions

Hi Champs!! I have a db for that i took full backup daily, and trans backups after every 15 mins. now tran backups are getting append into one...

HealthMonitor

Thread by: deepakontheweb, Apr 19, 2005, 4 replies, in forum: Third Party Tools

Hi All: I recently installed HealthMonitor Stable version 2.1 on my local PC for testing purpose. It#%92s a freeware, easy to install (requires .net...

Two different collations in a table

Thread by: deepakontheweb, Apr 18, 2005, 1 replies, in forum: General DBA Questions

I need to create a table with two diff collations.. like id bigint name1 varchar(200) Cyrillic_General_BIN (windows collation) name2 varchar(200)...

Two indexs on a column : 1billion rows

Thread by: deepakontheweb, Apr 14, 2005, 16 replies, in forum: Performance Tuning for DBAs

Hi all: I have a table which contains more then one billion records.. in it there is a integer column which is frequently being used for table join...

Scaling Out solutions on SQL Server 2000/ 2005

Thread by: deepakontheweb, Apr 5, 2005, 11 replies, in forum: General DBA Questions

Hi all, I am looking for different scaleout solutions for one of my application.. and doing r&d on these: - â€¢ Distributed partitioned views â€¢...

Tran & snapshot replication on A/P Cluster

Thread by: deepakontheweb, Mar 8, 2005, 5 replies, in forum: SQL Server Clustering

Hi all: I have 2 node active passive clusture, over it i need to establish snapshot replication for 3 db's and transactional replication for 4...

SQL Trace and replay on dev server

Thread by: deepakontheweb, Mar 4, 2005, 3 replies, in forum: Performance Tuning for DBAs

I have a clusterd server, there form i am collecting some sql traces using template given in microsoft sql server. but while applying the same traces...

Calculate Replication Overload on Publisher

Thread by: deepakontheweb, Mar 3, 2005, 2 replies, in forum: Performance Tuning for SQL Server Replication

[?]Hi all : I have a server with 7 user databases(total data 80GB) Daily growth in all 7 databases is around 500MB and transactions per sec on...

Cluster-Active Server down notification

Thread by: deepakontheweb, Dec 29, 2004, 3 replies, in forum: SQL Server Clustering

Hi All: I have 2 node active passive cluster, I need help to send a notificaiton mails as soon as my active sql switch to passive one.. sp3a : 2000...

Finding database actual filled size ??

Thread by: deepakontheweb, Dec 26, 2004, 5 replies, in forum: General DBA Questions

Hi all, How I can find the actual filled size of data/log (.mdf/.ldf) files, the same kind of report i need to prepare as we find in Enterprises...

sp_attach_db & Applying Transaction log backups

Thread by: deepakontheweb, Dec 21, 2004, 23 replies, in forum: General DBA Questions

Hi All, For one of my SQL 2000 production database, we are using daily volume level NAS snapshot backup of physical .mdf/.ldf files. Then after...