Search Results | SQL Server Performance Forums

Naming Conventions

Thread by: cutiepie, Aug 21, 2006, 4 replies, in forum: General DBA Questions

Hi all, I wanted to ask for the naming conventions in SQL SERVER.as in case of pl/sql server we have ..name_of_package.name_of_procedure thats how...

Filegroups in sql server...

Thread by: cutiepie, Feb 9, 2006, 4 replies, in forum: General DBA Questions

Hi all, this is my problem : SELECT * INTO Sales FROM Sales1 WHERE 0=1 ON [MyFG1] So if anyone can help, i'd like...

how to combine two UPDATES...

Thread by: cutiepie, Dec 9, 2005, 12 replies, in forum: T-SQL Performance Tuning for Developers

Hi all, my question is just if i have two update commands then how can i join them...here is my update: UPDATE LINKS SET PRICE = 999 FROM LINKS L...

row_id in sql server

Thread by: cutiepie, Dec 2, 2005, 21 replies, in forum: General Developer Questions

Hi all, i have a task that whenever i will write a select query then when the result comes then i should be able to write a column that should write...

Connection string in SQL SERVER 2005

Thread by: cutiepie, Nov 7, 2005, 10 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I am trying to make a connection string for the SQL SERVER..in all the sites i m getting To connect to SQL Server running on the same...

Database Diagrams Problem...

Thread by: cutiepie, Oct 17, 2005, 11 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I am trying to make DATABASE DIAGRAMs....I have restored a database called Tel from a backup file...n in that i have all the tables and...

server name problem....

Thread by: cutiepie, Oct 7, 2005, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I have installed SQL SERVER 2005 CTP,Version 9.00.1314 but the problem is...as soon as i m trying to connect..i gave the local server name...

how to create a table using schema other than DBO?

Thread by: cutiepie, Sep 27, 2005, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, i m using sql server2005 CTP...i created a database called TEL and in that database i created a user(in security) as USE [TEL] GO /******...

Procedure execution in YUKON

Thread by: cutiepie, Sep 23, 2005, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I wanted to ask...if there is someone who worked with pl/sql developer as well...then i wanted to know how can i TEST in the sql server like...

SQLDATETIME in BCP file

Thread by: cutiepie, Sep 22, 2005, 9 replies, in forum: SQL Server DTS-Related Questions

Hi all, i m having problems with the sqldatetime...i m using sql server 2005 YUKON..according to my format file i cant put the date on the right...

IO error while reading BCP format file

Thread by: cutiepie, Sep 21, 2005, 3 replies, in forum: SQL Server DTS-Related Questions

hi, i m having problems with the bcp file format... 9.0 2 1 SQLCHAR 0 4 "," 1 in_numbers SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 5 " " 2 values...

bcp file format....

Thread by: cutiepie, Sep 20, 2005, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, i wanted to ask on the same context of bcp...i m trying to insert two rows into a table using the bcp command prompt and the bcp file looks as...

insertion of data using DTS

Thread by: cutiepie, Sep 7, 2005, 2 replies, in forum: SQL Server DTS-Related Questions

Hi, can someone tell me how can i insert some data into a table using dts....i have a file .bcp that has all the rows but in the following format 1...

BCP...loading of a file...

Thread by: cutiepie, Sep 6, 2005, 4 replies, in forum: Performance Tuning for DBAs

Hi, can someone tell me...when i want to load a file (.ctl file or may b .bcp file)[to insert the table values inside the table schema] using the...