|
|
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
BULK INSERT and TRANSACTION... Posted by Mobileboy36 at 10/26/2007 12:00:00 AM Hello Group,
I'm using SQL Server 2005 SP1.
I have to import 16 text files every day. If there's an error in 1 of the
files, I need to perform a rollback, so that the datase is back in it's
original state.
I tried a structure like this one (I dropped all the details)
BEGIN TRY
BEGIN...more >>
Changing a field name into a column -- help normalizing Posted by andydlove NO[at]SPAM gmail.com at 10/25/2007 6:01:53 PM Hi guys and gals,
I need help with a table I have. It looks something like this:
Log | Var1 | Var2 | Var3 | .....| Var300
-----------------------------------------------------
1 | Data
2 | Data
3 | Data
I want to rework the table so it reads:
Log | Var | Data
---------------------...more >>
parameterizing a view Posted by jcriswel NO[at]SPAM gmail.com at 10/23/2007 4:12:15 PM This question probably reveals a basic misunderstanding that I have
about client server architecture so please take my confusion into
consideration with your reply.
Is there any way to call a view from a client program and pass
parameters to the server to filter the view before the result of t...more >>
Memory vs Database Size Posted by Bj=F6rn_Pettersson at 10/18/2007 1:31:46 PM Hi,
I've been searching on the net for general recommendations regarding
memory, for quite some time, but without any luck. I am sure there are
some neat formula out there to calculate how much memory a server need
for a particular size of database, but that doesn't help me I would
like to kn...more >>
A suitable SQL Server book for my goals Posted by Mukesh_Singh_Nick NO[at]SPAM yahoo.com at 10/17/2007 6:53:36 AM What's the best book to buy for learning MS-SQL Server for a database
programmer. I'll tell you my goals. I want a book that covers:
1) the theory behind operators (cartesian JOIN, cross JOIN, all the
JOINs, UNION, UNION all) and their comparison to mathematics/set
theory
2) writing complex...more >>
What are these queries used for? Posted by Mukesh_Singh_Nick NO[at]SPAM yahoo.com at 10/17/2007 6:44:57 AM I've come accross queries like this one previously but never got the
time to carefully study them form some book.
SELECT 1 WHERE 1 = 1
1) What do queries like these mean? From common sense, I can deduce
that it is some kind of a test for a boolean value, but the result is
already determin...more >>
Speed Issue After Upgrade Posted by Ben at 10/12/2007 2:45:39 PM We recently upgraded our MS SQL Server 2000 to 2005.
Here is what we did:
1. Perform backup of the database from the old server.
2. Created a blank database in the new server.
3. Restored the database into the blank database located in the new server.
After this process, there was an obvi...more >>
Linked Servers fail with Integrated Authentication Posted by jwgoerlich NO[at]SPAM gmail.com at 10/12/2007 1:39:35 PM Hello group,
I have two SQL database servers. The first is SQL 2000, default
instance, hosted on Windows 2000 Server. The second is SQL 2005, named
instance, hosted on Windows 2003 Enterprise Server.
The DBAs manage the SQL servers from their client computers. Clients
and servers are in one...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Transferring Data Between SQL SERVERS (Express) Posted by Matt at 10/11/2007 12:00:00 AM Hi All,
I have a few questions on transferring data between SQL Servers
(please keep in mind I am using Express 2005).
Situation:
-----------------------------------------------------
I have a SQL Server database on my server. I want this same exact
database on my local machine so that I ...more >>
Store Date/Time in SQL Server 2005 Posted by shahoo at 10/2/2007 1:21:01 AM I need to store Hijri Date in SQL Server 2005, but because it is year
1386 in Hijri calendar, SQL Server does not let me do that. I can
store it as simple text but it is not a good approach.
Can anyone help me please?
...more >>
Various DBs switching to Single User Mode by themselves!! Posted by swaykid NO[at]SPAM gmail.com at 10/1/2007 12:31:29 AM Hi,
We have a curious situation. We have a SQL 2000 server with about 25
dbs. About once a week or every 2 weeks (this varies) . What happens
is that 3 to 4 of the dbs appear in SINGLEUSER mode. This obviously
causes a problem.
Does anybody have any idea as to what might be causing this to
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |