Search Results | SQL Server Performance Forums

rows to columns

Thread by: joanne, Dec 6, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hello, I have a table with 2 columns: No SerialNumber 123 4GB6Y78 123 53F7TH 124 4GB6Y78 124 53F7TH 124 53E8BX the...

maintenance plan, best practices

Post by: joanne, Feb 19, 2007 in forum: SQL Server 2005 General DBA Questions

Many thanks for your suggestions

maintenance plan, best practices

Thread by: joanne, Feb 19, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, For sql server 2000 I never used the maintenance plan, I always used jobs to solve my maintenance problems. This year I will migrate to the...

dba interview questions

Thread by: joanne, Nov 28, 2006, 5 replies, in forum: The Lighter Side of Being a DBA

Last week last I passed an interview for a junior dba sql server job and the dba asked me these questions. 1.You#%92ve been given the task of...

connect to oracle with or without oracle client

Post by: joanne, May 30, 2006 in forum: SQL Server DTS-Related Questions

Thanks very much

connect to oracle with or without oracle client

Thread by: joanne, May 30, 2006, 3 replies, in forum: SQL Server DTS-Related Questions

Hi, Please, I need your help. I am a junior dba sql server and I want to know if I must install oracle client to connect to an oracle database, with...

use SAN with STANDARD edition

Post by: joanne, Jan 30, 2006 in forum: SQL Server 2005 Clustering

many thanks for your answer!

use SAN with STANDARD edition

Thread by: joanne, Jan 30, 2006, 2 replies, in forum: SQL Server 2005 Clustering

Hi, Can somebody tell me if I can implement a SAN solution with sql server 2005, STANDARD EDITION or it work just with enterprise edition? Many...

how to select products by category

Post by: joanne, Dec 9, 2005 in forum: General Developer Questions

Hi, <br />I will tray to explain again.<br />I want to send in my web page information from the database.<br />With my code, I see the category for...

how to select products by category

Post by: joanne, Dec 8, 2005 in forum: General Developer Questions

Hi, This is my table. I don' t know how could i use group by in my case. Classe_nameSub_classes Industrial ProductsHVAC Piping Industrial...

how to select products by category

Thread by: joanne, Dec 8, 2005, 6 replies, in forum: General Developer Questions

Hi, I need your help, please! I my aspx page I want to retrieve information from my sql server database and I don#%92t know how to select products...

backup and remote restore

Post by: joanne, Oct 31, 2005 in forum: General DBA Questions

thanks very, very much, satya

backup and remote restore

Post by: joanne, Oct 31, 2005 in forum: General DBA Questions

Hi, I forgot to tell you that I use sql server 2000, standard edition. derrickleggett, which article I must read? Thanks again to all.

backup and remote restore

Thread by: joanne, Oct 29, 2005, 5 replies, in forum: General DBA Questions

Hi, I am looking for a solution to my problem. I have two servers, a production server and a drp server. Every day I must create a backup for bd1 on...

a red x on the Replication Monitor.

Thread by: joanne, Oct 12, 2005, 2 replies, in forum: General DBA Questions

Hi, I have an application that use a stupid replication with source and target database on the same server. Now I want to test my restore plan and...

software to manage the performance

Thread by: joanne, Oct 11, 2005, 2 replies, in forum: Third Party Tools

Hi, I want to buy software to manage the performance of my 25 sql servers 2000. Can you suggest me something, please? Thanks in advance!

transactional replication

Post by: joanne, Aug 8, 2005 in forum: Performance Tuning for SQL Server Replication

Thanks very much for all answers. KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;886839 is very interesting. Thanks again

transactional replication

Thread by: joanne, Aug 5, 2005, 4 replies, in forum: Performance Tuning for SQL Server Replication

Hello, My company plan to use an application that will use a transactional replication (on the same server!!!). For me is for the first time when I...

replication question

Thread by: joanne, May 27, 2005, 1 replies, in forum: General DBA Questions

Hello, I want to know if I can do a replication between two databases on the same server(same instance) and between two databases on two different...

put a cmd file in a job

Post by: joanne, Mar 11, 2005 in forum: General DBA Questions

Because I did the test in query analyzer. The name is good; maybe is a problem with the path of java.