dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming


Discuss in the microsoft.public.sqlserver.programming forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.programming Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi all and happy new year, I have an architectural question regarding SQL Server's parallelism algorithm: Let's say I have a quad CPU machine and...
Ami Levin
01-03-2005 02:12 AM
Ami Levin Go to last post
9 85
In a traditional parent-child table which is self-joined, like a manager and employee, we would have a table such as this tableName:...
Au Ru
01-02-2005 10:25 PM
Max Go to last post
19 81
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the...
Stuart Leonard
01-02-2005 09:27 PM
Stuart Leonard Go to last post
2 86
Im trying to create an Index on a view and getting: Server: Msg 1936, Level 16, State 1, Line 1 Cannot index the view 'Northwind.dbo.tmpSpeed'. It...
ChrisR
01-02-2005 09:14 PM
Max Go to last post
10 102
create table tbl ( a numeric( 11, 0 ) not null, b int not null, c binary( 10 ) null ) Column a is a clustered primary key. Columns b and c each have...
Richard G
01-02-2005 07:14 PM
Ken Go to last post
7 72
Hello, We have a query that works fine on SQL7 but not SQL2000. It has to do with Degree of Parallelism between the two boxes. Here is the scenario...
paul reed
01-02-2005 06:59 PM
Ken Go to last post
8 89
I have a trigger 'TriggerChangeHistoryLicense' setup on the 'License' table (all DDL code included below) which populates the...
John A Grandy
01-02-2005 05:30 PM
Erland Sommarskog Go to last post
3 71
Hello, Suppose the following: DECLARE test CURSOR FOR SELECT nameID, firstName FROM testing DECLARE @array TABLE ( nameID INT NOT NULL, firstName...
Andrew Clark
01-02-2005 05:15 PM
Hugo Kornelis Go to last post
5 46
Hello All, I have a Table named DVDVideo in the Stage database (StageDB) as well as in the Production DB (VideoMediaDB). On a weekly basis, the data...
Gopinath R
01-02-2005 04:03 AM
Nigel Rivett Go to last post
2 40
given the field checked as a bit field, I want to flip the state of checked I would think set checked = not checked would work, but it...
Mac Davis
01-01-2005 10:17 PM
Mac Davis Go to last post
2 69
OK here goes... managed to restore a db to MSDE without the SQL Server client tools, used OSQL and all works well... thanks ! Now using OSQL I...
Murphy
01-01-2005 09:15 PM
Andrew J. Kelly Go to last post
1 81
I often use a chain of queries to produce a final output. Eg to prepare aggregate data, or to set up generic queries which are then used in...
Nickl
01-01-2005 08:55 PM
Nickl Go to last post
6 56
Hi, I have a very strange problem. I have one sql 7.0 box, and one sql 2000 sp3 box. An ASP app that we've been running off of the 7.0 is now...
Rob
01-01-2005 06:03 PM
Erland Sommarskog Go to last post
2 47
In case you haven't noticed:)
Pike
01-01-2005 05:02 PM
Steve Kass Go to last post
5 46
Could somebody point me towards some example cursor code that takes a list of numbers: 1, 2, 3, 5, 7, 8, 9 and formats it into a range of...
sg
01-01-2005 11:53 AM
--CELKO-- Go to last post
10 93
I need a CSV output file with the columns themselves surrounded by quotes. I've tried -c -t"," which gives me the commas, but have not yet found...
Eric
01-01-2005 08:44 AM
Erland Sommarskog Go to last post
2 54
I get this message when executing SELECT statement in SQL 2000: Location: recbase.cpp:1374 Expression: m_nVars>0 S PID: 51 Process ID: 2480 Why?...
Dzemo
01-01-2005 08:38 AM
Erland Sommarskog Go to last post
3 47
If I have a table of customer products (let's say product A is a trial and Product B is a full version), how would I write a query that would...
Willie Bodger
01-01-2005 08:19 AM
--CELKO-- Go to last post
4 58
I was hoping for a more streamlined error handling now that we get try-catch but I seem to be running into a few problems. One very important idiom...
Alexander Jerusalem
01-01-2005 05:07 AM
Alexander Jerusalem Go to last post
3 52
Hi all, I've been having problems with an over night job since the 20/21st December, basically the import had been failing because of a problem with...
Rob Meade
01-01-2005 03:07 AM
mark baekdal Go to last post
3 53
I have a clean up project to delete a hundred million rows (from a table of 300 million) that are stale. These rows are children of about 500 parent...
Rex
12-31-2004 06:52 PM
Gert-Jan Strik Go to last post
3 61
sql2k. i've read it some where that transaction logs and the TempDb should be place on a RAID 1 (mirror) drive. I have two questions about the...
=== Steve L ===
12-31-2004 05:34 PM
=== Steve L === Go to last post
4 39
I have a table of student incidents, including absences from school, listing the student ID, the date of an incident, and whether it was an...
Nevyn Twyll
12-31-2004 04:33 PM
Nevyn Twyll Go to last post
3 47
I'd like SQL Server to email me on job failures. I've setup a profile through the mail icon in control panel and tested it successfully. When I go...
Brett
12-31-2004 03:40 PM
Chau Nguyen Go to last post
7 71
I have a partioned view called members. Partined based on status of the members. Tables : members_11 ( check status=1) members_22 (check...
Abraham
12-31-2004 11:54 AM
Robert Harmon Go to last post
8 61
We have VB program who queries data (using stored procedure) from a SQL Server 2000 db. The database can grow as much as 10 million records. When...
Paul fpvt2
12-31-2004 11:35 AM
Paul fpvt2 Go to last post
16 101
Hi, I have a suspicion about using Bulk Insert/update on indexes tables whether they bogged down performance or not. Or dropping indexes and/or...
Siz
12-31-2004 11:23 AM
David Gugick Go to last post
4 45
Hello, On a users table I have a field which indicates if the user is authorized or not. Is there a Boolean type in SQL database 2000 or should I...
Miguel Dias Moura
12-31-2004 09:34 AM
Hugo Kornelis Go to last post
2 49
The first time the following script runs, it successfully updates permissions. Even if I change the database, the script fails the second and each...
Garibaldi
12-31-2004 08:21 AM
garibaldi Go to last post
3 54
Hi all, I have experienced a problem over the last few days with an import job failing - this is being investigated, but I thought it best to setup...
Rob Meade
12-31-2004 08:17 AM
Rob Meade Go to last post
8 38
Hi, I Have the following bit of SQL in a stored procedure: SELECT DISTINCT ref FROM U_NFADHOC WHERE CONVERT(DATETIME,DATE) BETWEEN...
Robert
12-31-2004 07:31 AM
Tom Moreau Go to last post
1 55
Every time I startup Query Analyzer and connect a session to the database server, it always by default connects to a certain database. I would...
Mike Labosh
12-31-2004 07:29 AM
Tom Moreau Go to last post
6 57
need help resolving this concatenation error Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) Syntax error converting the varchar value...
TJS
12-31-2004 04:32 AM
Hugo Kornelis Go to last post
1 59
Hi Would it be possible for someone to check my code for the stored procedure shown below. I'm passing a date parameter into it, and then checking...
Robert
12-31-2004 04:27 AM
Hugo Kornelis Go to last post
1 40
Hi all, I have a problem with a conversion from some functions in Oracle to SQL Server (T-SQL). The functions are: to_char(time, 'dd-mm-yyyy...
Gigio
12-31-2004 03:36 AM
Hugo Kornelis Go to last post
3 53
Hi! Is it possible to create an database in SQL Server generated in VBScript?? Kind Regards Mehran
merre
12-30-2004 08:45 PM
Tom Moreau Go to last post
3 57
Thanks for the reply. I was able to find http://www.databasejournal.com/features/mssql/article.php/3339681 which looks promising. I got this to...
DavidM
12-30-2004 07:10 PM
Aaron [SQL Server MVP] Go to last post
6 46
did someone move the thread "to bit or not to bit" to another newsgroup ?
John A Grandy
12-30-2004 05:44 PM
David Gugick Go to last post
1 54
Hello I have 3 tables CREATE TABLE #Players ( Player char(1) ) CREATE TABLE #Scores ( Score smallint NOT NULL,
Lasse Edsvik
12-30-2004 05:40 PM
Hugo Kornelis Go to last post
14 110
Hi all, Does anybody know of a way to perform UTF-8 conversion as part of returned SQL statement from an nText field? I'm dealing with a...
Rick Strahl [MVP]
12-30-2004 04:50 PM
Erland Sommarskog Go to last post
3 58
Hello! Error Message: "Operation is not allowed when the object is closed." What I have is a stored procedure on SQL server that goes and checks...
Conax
12-30-2004 03:49 PM
Bob Barrows [MVP] Go to last post
3 65
How can I get the result show below. The rules also showing below. Any help would greatly appreciate. Thank you in advance. IF...
Lam Nguyen
12-30-2004 03:25 PM
Lam Nguyen Go to last post
3 51
Here is my query and it is taking forver to run. Is it in an infinate loop or no? Thanks for an answers. Use...
tarheels4025
12-30-2004 03:19 PM
Armando Prato Go to last post
1 168
when utilizing ADO.NET in vb.net or c# ....... is SQLDataReader.GetBoolean() the best way to retrieve a SQL-Server database column of datatype bit...
John A Grandy
12-30-2004 02:52 PM
John A Grandy Go to last post
2 87
Is there any way to get around the prohibition of 'create database' statements in triggers? What I'd like to do, ideally, is have an insert trigger...
Preston
12-30-2004 02:44 PM
Anith Sen Go to last post
6 49
Don't blame me for this table. I am just trying to code on it. The Table has 5 fields in it. I have an resultid, questionID, OptionTextboxValue,...
DaveF
12-30-2004 02:07 PM
Ryan Go to last post
2 57
Hello, Is there a function to convert NULL values to zeros so that they can be used in arithmetic calculations? Any help is appreciated for this...
Chris
12-30-2004 01:32 PM
Barry Go to last post
3 48
Hi, I have created a view that uses union all for different fiscal years. example: select * from table1 union all select * from table2 I have...
Chuck
12-30-2004 01:26 PM
ChuckD Go to last post
10 91
Hi We had some problems with the precision of large incomes in a swiss social security application using SQL Server 2000. So I did some tests:
Justus
12-30-2004 01:17 PM
James Ma Go to last post
6 80
I currently have a process where I get zip files with dbase tables. I then take the dbase tables and import them into a staging table. The issue...
AshleyT
12-30-2004 12:16 PM
Anith Sen Go to last post
1 54
Post New Thread

Display Options
Showing threads 47301 to 47350 of 69251
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.