SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Faster alternative to count(*) for a single table in a database?

  Currently we have multiple applications that archive data to the same database (and possibly the sa…

  smccloud

  2 replies

  16 years ago

  By: smccloud

• Forcing a Select to use a specific index

  I have been thrust into the role of DBA at my company. Unfortuanately I have no training. Hopeful…

  meichner

  12 replies

  16 years ago

  By: GSquared

• sql problem

  Hello everyone i m a beginner in sql i want to know that how to insert a table column as the parame…

  dheerajbaghel

  8 replies

  16 years ago

  By: mayank jarsaniya

• Converting a date string to DATETIME

  I have an interesting conversion issue... Run these statements (SQL server 2005): SELECT CONVERT(DA…

  Lark-1120090

  1 replies

  16 years ago

  By: GSquared

• Bulk alter table

  ok where do i start i'm a complete novice and have to have this database changed asap. I'm currentl…

  paulj_p4

  8 replies

  16 years ago

  By: RBarryYoung

• How often is a stored procedure run?

  I need to provide a report on how often a Development team Stored Procedures are run ( or not ). Th…

  paul.muswellhill

  4 replies

  16 years ago

  By: Gail Shaw

• bcp - Importing Non Native Data

  Greetings All. I would really appreciate any input on the following problem. I am trying to use the…

  charles-734391

  1 replies

  16 years ago

  By: Rudyx - the Doctor

• sql problem

  Hey i m with a new problem. can i find under root of a number in sql.

  dheerajbaghel

  2 replies

  16 years ago

  By: Lowell

• Blocking issues

  We have a database which is accessed by 24x7. However, we have a table which needs to be updated on…

  SQL Guy 1

  5 replies

  16 years ago

  By: TheSQLGuru

• insert into

  I am trying to insert into table1 all selected data from table2. In table1 I have one additional c…

  gcoe

  4 replies

  16 years ago

  By: gcoe

• SQL on Parent/Child Tables (Left Outer Join / Right Outer Join)

  I have a report which attempts to grab Marketing/Sales data based on LeadSources. There is a Primar…

  nturner

  1 replies

  16 years ago

  By: spaghettidba

• sql problem

  hello everone i have a new problem. Is this possible to send the data from a sql table to excel an…

  dheerajbaghel

  1 replies

  16 years ago

  By: Silverfox

• restore adds collation to nvarchar columns

  When restoring a database backup to an SQL server 2005 instance (9.0.1399 patch) all nvarchar and n…

  blom0344

  5 replies

  16 years ago

  By: blom0344

• Checking for Triggers in a SQL2005 Database

  I am currently working with a SQL2005 database that was specified to use triggers to log changes to…

  Clive Chinery

  2 replies

  16 years ago

  By: Clive Chinery

• SQL server Error log rotation

  I'm having a problem where a ton of 318 error jumped my error log up to 1.8 GB in size. Is there a …

  mark gordon

  12 replies

  16 years ago

  By: Rudyx - the Doctor