What database naming conventions do you use? Hi, I spent my whole Sunday reading database naming conventions,. And this only made me more...

Marcello

06-24-2008 02:57 AM
Philipp Post

Can anyone please explain me main differences between relational DB and warehouse (Point me to web site) ? Apart from theoretical differences I...

Karol R

06-23-2008 09:31 PM
Plamen Ratchev

I have two tables, Sections and Enrollments. The two tables can be joined on a key. The records for the enrollment table are imported from another...

t8ntboy

06-23-2008 07:54 AM
Philipp Post

I am trying to script the process RESTORE FILELISTONLY using an Exec() statement. I cant seem to get it to work with a variable. Here is what I...

spattag@gmail.com

06-22-2008 06:15 AM
spattag@gmail.com

On Jun 20, 6:56*pm, Annonymous Coward <m... (AT) home (DOT) com> wrote: Use SQL DMO. Its got a C++ interface. More information is available in the...

sifobo

06-22-2008 04:29 AM
Arved Sandstrom

Yksinkertainen kysymys: "Mitä Suomen valtion kansantalous saa tehtyä niillä 100% puhtailla energiamäärillään, joita sille tuottaa esim....

Tino Mattson

06-21-2008 10:51 AM
Tino Mattson

I have SQL Server database tables with international character support. Is there any way I bcp out the table in UTF-8 format csv files?

Jay

06-21-2008 08:44 AM
Erland Sommarskog

I have a SQL Server table with nvarchar type column which has not null constraint. I am inserting empty string ("") from Java to the table column....

Jay

06-20-2008 05:01 PM
Erland Sommarskog

Hi all, After finishing a script in Toad for MSSQL, I saved and closed the file in Toad. I then kicked off our staging process which moves the file...

sherifffruitfly

06-20-2008 02:33 PM
sherifffruitfly

How can I cross join all rows of table A with 1000 rows (first 1000, any 1000) of table B?

metaperl

06-19-2008 05:36 PM
--CELKO--

i need a little syntax help with a SP. i have a datetime field that is part of the search criteria. it may be null in which case it should be...

mcnewsxp

06-19-2008 03:56 PM
mcnewsxp

Hi, I perform BulkCopy from Excel file to SQLServer using DbDatatreader(obtained using OleDbConnection). In the Dbdatareader I actually select the...

gshetty

06-19-2008 01:21 PM
gshetty

Dear all, I'd like to ask for your advice in the following problem: I've developed a web app using sql 2005. Now that I've migrated the files to the...

Zark3

06-19-2008 01:37 AM
Tony Rogerson

I'm using the SqlBulkCopy object to bulk insert large DataTable's into SQL Server. Its working well except tables with IDENTITY columns...

Dave

06-18-2008 05:07 PM
Dave

Does it make sense to create an enterprise database design where there is 1 table for people, another for addresses, another for phones...etc. The...

DJE

06-18-2008 02:00 PM
Arved Sandstrom

Anyone have a link to these? (are they even officially out there yet?) A google search and a search of MS's website revealed nothing. Will SQL 2008...

Greg D. Moore \(Strider\)

06-18-2008 12:25 PM
Greg D. Moore \(Strider\)

I just moved a SQL 2000 database to a new server (backup/restore). This server is much beefier with respect to hardware. The problem is that the...

michael

06-18-2008 07:38 AM
Dan Guzman

Dear all, Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based Oracle and SQL database backup manager for Windows and available...

sifobo

06-18-2008 06:00 AM
sifobo

Hi guys. We have an application. There are 3 (at the moment) different sections, each has access to it's own 'Diary'. A section is like, 'Sub...

Cralis

06-18-2008 02:48 AM
Ed Murphy

Transmutaatiotekniikasta. *Maassamme ydinalalla on tuskin mitään niin tarkoin TABU:na pirettyä systeemiä, kuin mahdollisuus neutraloida edes osin...

Kaapo

06-17-2008 02:28 PM
Kaapo

Hi, I have got the following situation please give me some ideas how to solve/work around it. Current situation: Everyday day about 10 million...

Tawfiq

06-17-2008 01:46 PM
Gert-Jan Strik

Hi, I'm developing some Powershell applications that will need to pull data out of some sort of container. I've been playing around and had some...

Kryten

06-16-2008 05:05 PM
Erland Sommarskog

Hello there, I am migrating an Access database to Sql Server. There are many many problems with the access database (Schema and data) that need to...

John Sheppard

06-15-2008 11:49 PM
John Sheppard

I have a Stored procedure on a SQL 2005 server. It inserts a new record into t_people and correctly retrieves the id using SCOPE_IDENTITY. It then...

06-14-2008 11:00 PM
Kevin Zhong

Is there a way to look at the internals of built-in stored procedures and see what they are doing? sp_help provides little information.

nambia05

06-14-2008 10:57 PM
Kevin Zhong

I am looking for a way to select some data from a Access database into my SQL database. In Enterprise manager, I want to do someting like: SELECT...

frank

06-14-2008 10:48 PM
Kevin Zhong

( www.G lobwholesale.com.cn ) Discount, LRG jeans, Evisu jeans, ED hardy jeans, COOGI jeans, Gino Green Global jeans, Lacoste jeans, G-star jeans,...

cheaptshirts@126.com

06-13-2008 08:37 PM
cheaptshirts@126.com

Dear all, We recently migrated a SQL database from one server to another. Now, when you try to run some code in an Access Database which links to...

David McColl

06-13-2008 05:12 PM
Erland Sommarskog

I have some SQL code I wrote that returns about 15,000 rows (using a group by statement, raw data is around 1mill rows). In this code I have a few...

mike

06-13-2008 12:40 PM
Plamen Ratchev

HCL, Aricent, Infosys and many more companies hiring fresh & experienced engineers , FIND UR DREAM JOBS AT GIVEN BELOW LINKS: - ...

Career Point

06-13-2008 10:39 AM
Career Point

Rick, That's almost like asking why we should bother with database connection pooling. It's a question of efficient use of resources and avoiding...

Bill E.

06-13-2008 09:00 AM
Armen Stein

I just upgraded my SQL 7 to SP4 (actually MSDE 1.0). I used sql70sp4.exe from the Microsoft site, ran the setup program, and everything seemed...

Neil

06-12-2008 11:04 PM
Neil

I had a strange situation with a view in SQL 7, that I could use some input on. I had a very simple view -- select a, b, c from table1 where x=y and...

Neil

06-12-2008 04:50 PM
Neil

Hi, We have a table of users with about 10000 rows. We have to import a large text file into this table. While doing so we would like to ensure that...

Yashgt

06-12-2008 12:52 PM
--CELKO--

Hello , O may ask this before. I need an SQL for learning purposes to execute examples at books. What are the most easy simple SQL engin to do that...

happytoday

06-12-2008 12:47 PM
--CELKO--

SQL Server 2005 SP2 What is the significance of the owner of a database being sa as opposed to some administrative (or non-administrative) local...

aj

06-12-2008 07:26 AM
Dan Guzman

Hi, I have a date field stored as an INT and need to convert to a date format mm/dd/yyyy. I'm having trouble determining what the starting date...

Artie

06-12-2008 06:49 AM
--CELKO--

Hello everyone, I'm trying to implement full-text search for the albanian language. What's the best way to implement it? Based on my current...

Albert

06-11-2008 09:19 AM
Albert

YLE Ajankohtainen kakkonen 13.05-08:" Nyt ei olle enää KENELLEKKÄÄN epäselvää, että maailma on ajautumassa ennenäkemätrtömiin...

Mauno Sillanpää

06-10-2008 07:59 PM
Mauno Sillanpää

Hello, I'm working on a DB on which I can run only SELECT commands, so I'd like to modify these UPDATE commands, into one SELECT command, which makes...

carmelo

06-10-2008 04:03 AM
carmelo

I have problem with sql server configuration tool. it can not be opened This error I get: Snap-in failed to initalize. Name:Sql server...

lopina

06-09-2008 04:44 PM
lopina

I have two tables. I want to get one column from table B into table A. I have added a "blank" column in table A for that information. The "link"...

scadreau@gmail.com

06-09-2008 04:33 PM
Erland Sommarskog

Okay...here is what I need to do. I have an Oracle Connection that I want to pull records from into an SQL table. I have a view in the SQL server...

nntp.charter.net

06-09-2008 03:29 PM
nntp.charter.net

I have an odbc application that is designed to use an application role. The role has been set up already outside the application and it exists in the...

nambia05

06-09-2008 02:23 PM
Erland Sommarskog

Hello, I'm working on a DB on which I can run only SELECT commands, so I'd like to modify this UPDATE command, which makes use of CASE: update...

carmelo

06-09-2008 11:50 AM
carmelo

Hi, we just set up a SQL Server 2008 on Windows Server 2008 (configured as file / webserver, 16 GB memory, 4 dual core processors, 6 internal disks...

Andreas Zimmermann

06-09-2008 11:49 AM
Andreas Zimmermann

I need to figure out programmatically if an instance is a cluster or non-cluster. Also, if it is a cluster what are nodes and associated cluster...

Virendra

06-08-2008 03:10 PM
Plamen Ratchev

Hi all: Quick question... Is there a capability within MS Sql/Server to automatically generate an email upon the completion of an event? thanks

Vinny

06-08-2008 10:31 AM
Greg D. Moore \(Strider\)

Lisää aurinkosähköä samalla rahallaAurinkosähkön suuri ongelma on hyvin tiedossa.------- Ongelmasta yritetään irrottautua valoa keskittävillä...

Henri Heinonen

06-08-2008 10:16 AM
Henri Heinonen

Mikä ihmeen 80%? Lukasin lehden 5.6.2008 ja nyt on suorastaan outoa ilmassa. Miltei jokainen Suomen ja MYÖS Ruotsin ydinvoimalat kaikki pörrää...

Pauli Öhman

06-08-2008 04:02 AM
Pauli Öhman