Getting started with SQL Server Forum

I need some opinions about storing text or Word documents in SQL server

Thu, 26 Nov 2009 03:34:12 Z

I'm developing a website database in Microsoft Access, but my design needs to based on migration to SQL Server (at which point I will contract some professionals).

1. Most records will contain a significant amount of text.
2. I want to automate the procedure of opening and saving a text document within the forms.

What's the best way of storing and retrieving the text? For my purposes MS Word is an excellent text editor, but I'm open to any suggestions. In Access, the ability to view OLE objects (i.e. Word documents) in the form is handy.

Most records would have 1,000-2,000 characters with occasionally 10,000-15,000 characters.

Thanks Peter

SQL 2008 T-SQL and MS Access 2007 SQL (ANSI) Compatibility

Thu, 26 Nov 2009 18:02:04 Z

Hi Everyone,

Hoping someone can assist me with this question.

We have an Access DB that was originally created with Access 2003, and then was recently converted to work with Access 2007. We are now in the process of preparing to migrate the Access 2007 DB to a SQL Server Standard 2008 server DB. This will be a brand new SQL Server DB. The current desktop operating system is windows XP SP3. Following is the proposed architecture for the new setup:

The architecture will be an Access 2007 front-end Linked to a SQL Server 2008 Standard edition Back-End. The Front-End will use Access 2007 Run-Time for Forms and Reports. The back-end will store all the data (tables, stored-procedures, etc.). The desktop operating system is Windows XP SP3.

Following are the questions I have:

1. Are the Access 2007 SQL Datatypes and commands compatible with T-SQL Datatypes and commands within SQL Server 2008 Standard Edition ?

2. Can you please suggest the best practices and any additional information when using Access 2007 as a Front-End and SQL Server 2008 Standard Edition as a Back-End.

Your help is MUCH appreciated !

Thanks,

Jason

SQL 2005 - Update statistics,DBCC job status

Fri, 27 Nov 2009 09:31:13 Z

Hi ,

Can anyone tell me any DMV or query to find the status of update statistics job is running currently in which table in SQL 2005 and also queries to find out DBCC job status

tru or false

Fri, 27 Nov 2009 15:33:52 Z

Microsoft Award Team.
Baley House, Har Road
Sutton, Greater London
SM1 4te United A Kingdom.
Batch: 12/25/0340

Import Foxpro 2.6 data tables into MSSQL 2005

Fri, 20 Nov 2009 16:00:35 Z

Hi,

I'm looking for a way to import the data, periodically from Foxpro 2.6 data tables into MSSQL 2005, are the any tools that exist?

Thanks

Nick

Class does not support aggregation

Fri, 23 Dec 2005 04:29:55 Z

Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)

Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ISqlToolsVSHlpFactory.CreateHierarchyWrapper(Guid& clsidInnerHier)
   at Microsoft.SqlServer.Management.UI.VSIntegration.SqlWorkbenchHierarchy.CreateHierarchyWrapper(Type typeToWrap, ILocalRegistry localReg)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.get_SqlVirtualProject()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.InvokeDesigner(IManagedConnection connection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.Invoke()Hi there,

I'm using SQL Server 2005 Dev. with Windows XP Pro. SP2.
50GB free space with 1GB of RAM
After I installed SQL Server with no problems.
I tried to open a table in AdventureWorks database and I'm getting an error:

Could some one tell me what is going on ?

Thanks an advanced

Oded Dror
Email: odeddror@cox.net

SQLServerAgent not starting

Mon, 27 Feb 2006 14:46:50 Z

Hi all,

I have a maintenance plan on SQL2000, that is backing up the database.

It is under Management/SQL Server Agent. When I try to start the job, I got an error, saying: Error 22022 SQLServerAgent is not currently running so it cannot be notified of this action.

But, when I try to start the SQL Server Agent (in Services), it stops directly with the following information: The SQLAgent$Sharepoint service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

When I try to start it from the SQL Server Service Manager: no reaction at all!

Do CTE improves performance?

Fri, 27 Nov 2009 10:33:04 Z

Hi,

Will CTE improve the performance when quering from a large database. Kindly please provide me the information.

Thanks,
Gnanasekar Babu

Using Query Graphical Tool Then Copying Column Headings

Wed, 25 Nov 2009 18:48:01 Z

I have a client that just started using SQL 2005 and is used to being able to copy the results of a query built with the GUI view builder in 2000. In SQL 2005, the column headings are not included.

I always use the text queries and unable to find a solution for her. I know of the option that exists in the Options > Query Results > Results to Grid > Include column headings, but that does not work with the result of a VIEW vs. a Query. (Nor does it work with an Open Table)

The idea is that when I setup a view it’s a drag/drop type of query building (query building for dummies if you will). Once I have a view and click the Execute icon it will return all the records selected by the View. However, when I click the upper left/top box to select all rows and column and then try to copy/paste the records into Excel all the data copies just fine but the field name/column headers are not there.

How can I get the header fieldname data to copy/paste from View result set that I'm able to copy from a Query result set? Hopefully there is a simple solution out there that I have just not run accross, yet.

Connecting from APP to DB server giving TCP Provider, error: 0

Fri, 20 Nov 2009 16:55:49 Z

Setup: APP server (Win Server 2008, IIS7) and DB server (Win Server 2008, SQL 2008)

What Works:

Running "SQL Server ODBC Data Source Test" connecting to DB server returns "TEST COMPLETED SUCCESSFULLY"

What Fails:

Connecting from Ms SQL Server Management Studio on APP Server to DB Server returns the following error

Trials made with no lucks:

- Checked "Allow remote connections to this server" on DB Server
- Increasted Remote Login Timeout to 600
- Disabled connection pooling on ASP.NET connection string

One strange thing to note:

1) when connecting to DB server using ASP.NET code and trying to execute a stored procedure that list out all fields of one row record from one table, it gives the same error as shown in above screen capture

2) but when changing to execute a stored procedure that list out one field of one row record from one table, the ASP.NET code was successfully executed!

3) it seems like the error will occur if returning data is larger than a certain size (in which the size is real small! almost like... a network packet size?)

any help would be very much appreciated!!

thanks in advance!!

Problem Creating SQL Database

Thu, 26 Nov 2009 20:58:54 Z

Hello,

I am building a database in SQL where I want to have following columns

ID - integer

username - text

Password - text

in MySQl I was using Type- int(11) that was - auto_increment, was generating ID on it's own.

how can I do this in MS SQL?? which type should I use for ID??

I tried - int -- but it required 32 digit number

I tried uniqueidentifier- but also not warked

here is the picture PICTURE

cannot connect to server in sql server management studion

Thu, 26 Nov 2009 06:40:15 Z

i successfully installed sql server 2008 express and management 2008 express. i can't connect to server, it's asking for a server name. how can i have that? i'm on a core2duo windows 7 setup. i tried using my computer name, it failed. i'm trying to learn sql on my own and this is supposed to be my first step. thanks!

Connection is not open in visual studio 2008

Wed, 25 Nov 2009 07:58:47 Z

hi,

i create simple webform by using c# i create database by using sql server 2005.
i establish the connection by writing some string code and initialize the object
but when i run the webform i get the msg the sqlserver connection is fail to open.
I need help plz.....
i m using sql server management studio 2005 through windows authentication.
error msg : serverxyz login to fail the connection is not open.

Guys who can help me with regard to this?

Thu, 26 Nov 2009 04:59:23 Z

Hello guys, i'm storing a set of records in my table in database using sqlserver. and i retrieve them in my front end application using C# now this is how i retrieve my records form database.

I have a list view with more than 20 columns. the problem i have is one of my column is named Birthdate and the way birthdate is being inserted in the table is used by 3 combobox. meaning so when i INSERT COMMAND for database when it comes to birthdate it gets the selectedItem of 3 combobox following cbo.Month, cbo.Days, cboYear. so i get each selectedItem of it. the problem is while i wanna populate them from database into listview. lets say for instance im using subitem[4].text for my edit. since the format of my birthdate column in database is mm/dd/yyyy for example february 21 1989 is 2/21/1989 this is how my birthdate fields are stored in my database i dont know how to separate the month day and year from the column because i wanna retrieve them as

cbo.Month.SelectedItem = "2" cbo.Day.SelectedItem = "21" cbo.Year.SelectedItem = "1989" how can i have it this way,

knowing the fact that my comboboxes already contain the years complete month and 31 days in it's item and they are all formed in number format. it just so happens that when it goes to database using INSERT COMMAND it will be like VALUES("' + cboMonth.SelectedItem.ToString() + "/" + cboDay.SelectedItem.ToString() + "/" + cboYear.SelectedItem.ToString() + "', '" etc..... thats how my birthdate column is being filled now i am having problem for retrieving it while i wanna split them back into 3 parts.

any concern will be appreciated .

Thank you

-Maf

Strange problem, unable to insert single quote (already add in an extra single quote) for one particular table

Wed, 25 Nov 2009 10:11:28 Z

I have a very strange problem, I can update the table with single quote, but I cannot insert single quote. It only happen for this particular table in the database. Is there any suggestion on what I should look at?

I had already added in an extra single quote in my sql statement, something like this:

insert into Table_1 VALUES ('hello''s world','xxx')

How to Create a Temp Table from a SP that creates a Matrix (Variable Columns)

Tue, 24 Nov 2009 09:57:09 Z

Is there any way that I can create a temp table based on the output of a Stored Procedure that could return various numbers of columns. I.e. I want to EXEC a SP into a #Table without declaring the columns of the #Table prior to execution?

MerlinJnr

Sample Databases

Wed, 25 Nov 2009 00:10:14 Z

I have sql server 2008 management studio installed at home. I have been unsuccessful installing the Adventure database. I think it may only work for sql server 2008 and not management studio. Could someone send me the link for sample databases that work with management studio. Thanks.

SQL server Import wizard issue - not able to import a FLAT file

Thu, 26 Nov 2009 00:55:51 Z

hello all,

I am just trying to import data into a table. The flat TXT file has only 2 columns:

time,filepath
00:00,/All_V/DBEventLog/MIL_EventLog.txt
00:00,/All_V/Dashboard/FCASfCounterData.cab
00:00,/All_V/DBEventLog/CI_EventLog.txt
00:01,/All_V/Counters/Counters_WA003_
00:01,/All_V/Counters/Counters_SERV036_
...

but the wizard is giving me the following errors:

Operation stopped...

- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Success)
- Pre-execute (Success)

Messages

- Executing (Error)

Messages

Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)

Information 0x402090dc: Data Flow Task: The processing of file "C:\tools\FtpMonitor\ex091124.txt" has started.
(SQL Server Import and Export Wizard)

Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "filepath" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task: The "output column "filepath" (14)" failed because truncation occurred, and the truncation row disposition on "output column "filepath" (14)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task: An error occurred while processing file "C:\tools\FtpMonitor\ex091124.txt" on data row 3.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - ex091124_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)

Error 0xc0047039: Data Flow Task: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.
(SQL Server Import and Export Wizard)

Any ideas?

Thank you

JCDS

MS SQl Server 2005 Developer Edition

Tue, 24 Nov 2009 16:22:15 Z

Deos anyone know if there are any other limitations to using the SQL Server 2005 development edition apart from not being able to use it on a production environment. I would like to know if I will be able to access other remote SQL servers once I install the development edition on my local machine. Or will I be restricted to using only SQL server that is installed only on my machine?

Where is the Northwind Database?

Mon, 12 Oct 2009 17:13:07 Z

Hi, newbie here. I downloaded SQL Server Express and thought that the Northwind sample database comes with it but I was wrong (once again). I thought it would be easy to figure out where it is hiding but apparently everybody in the world knows how to do this but me so there isn't much information on how to get it. Can somebody show me the link where it is along with the installation instructions?

Thank you so much.

Dave

A friend is one who sees through you and still enjoys the view. -- Wilma Askinas (1926- ) American Author

select query problem

Tue, 24 Nov 2009 07:37:40 Z

hi all,

i have a select query please have a look

select distinct ID,Name,Address,[Home Tel],[Mobile tel],[work tel],Email,[Birth date],Rate,Notice,Created,Modified,[last cv],Deleted,[q comments],[last typed],Recruiter from [dbo].[vItrisRepository] 
where (name like 'samy%' OR name like 'samy%' OR name like 'samy%' OR name like 'samy%')  AND skills = 'Middle East' AND skills = 'Resident Engineer'

See the last and part " AND skills = 'Middle East' AND skills = 'Resident Engineer' "

Which is not working

now the second one

select distinct ID,Name,Address,[Home Tel],[Mobile tel],[work tel],Email,[Birth date],Rate,Notice,Created,Modified,[last cv],Deleted,[q comments],[last typed],Recruiter from [dbo].[vItrisRepository]
 where (name like 'samy%' OR name like 'samy%' OR name like 'samy%' OR name like 'samy%')  AND skills = 'Resident Engineer'

see the part " AND skills = 'Resident Engineer' "

This is working fine but the first one is working.

i am generating the query programatically according to the user selection

but i cant seems to figure out why its not comming at the first time

Thanks in advance
Roma

Access to MS SQL: Cascading deletes

Fri, 20 Nov 2009 10:07:30 Z

I’m a little confused why nobody else has posted about this problem, but then again, I’m not that familiar with databases and it might just be my own stupidity that prevents my DB from working.

I used the "Microsoft SQL Server Migration Assistant 2005 for Access" to convert our Access Database for MS SQL 2005. Most of the conversion went flawlessly but some cascading deletes where left behind in the process. Here is an excerpt from the MSDN documentary that pinpoints the problem:

Unlike Access, SQL Server does not permit circular referential integrity. [...] To circumvent this issue in SQL Server, you will need to remove the referential integrity constraints from the tables, and create a trigger on each table to perform the updates. For more information about using triggers, see Enforcing Business Rules with Triggers.

It sounded like a dirty solution to me, but, anyway, I started to create triggers and put them to wherever cascading delete didn't work anymore. My triggers look like this:

CREATE TRIGGER tgr_del_child

ON tbl_Parent

AFTER DELETE

BEGIN

DECLARE @delId Int

SELECT @delId = (SELECT parent_ID FROM Deleted)

SET NOCOUNT ON;

DELETE tbl_Child FROM tbl_Parent, tbl_Child WHERE tbl_Child.child_FS_Parent = @delId

END

So, I basicly look up the key of the deleted row in the Parent-Table. Then I delete every entry in the Child-Table in which this key appears as a foreign key. This works perfectly untill I delete more than one row in the Parent-Table. This line causes the crash:

SELECT @delId = (SELECT parent_ID FROM Deleted)

So, it's obvious to me why it doesn't work, i just don't know how to avoid it. Can I save a set of IDs instead of a single one? Or is there after all a better solution than triggers to regain my cascading deletes? Redesigning the database is not really an option at this point; we just need it up and running soon.

Again, I’m not that familiar with databases. Thanks for your help!

problem executing scalar valued function in remote database's View

Mon, 23 Nov 2009 12:54:45 Z

I have my local DB say "HD" on my machine

and remote server say "RM-S/2005" has DB "R-DB",
in R-DB there is scalar valued function "Function1(EmpId)"

In my local DB i need to create a view using Function1(Empid)

view is say , "view_ProjAccToEmployee"
as follows,

SELECT    A.ProjectID, A.ProjectName,
         [RM-S/2005].[R-DB].dbo.Function1(B.EmployeeID) AS EmployeeId
FROM         [RM-S/2005].[R-DB].dbo.Project AS A INNER JOIN
                      [RM-S/2005].[R-DB].dbo.Employee AS B
                                                     ON A.ProjectID = B.ProjectID and B.IsActive=1

It gives me error as follows,
Msg 207, Level 16, State 1, Procedure view_ProjAccToEmployee,
Invalid column name 'RM-S/2005'.

I have added RM-S/2005 to linked server. Can't figure out what is problem
because for other things like tables in [RM-S/2005].[R-DB] it works fine.

.

MAX(SHIFT_END_DATE) problem

Wed, 25 Nov 2009 09:21:50 Z

Hi All;

I am trying to get the last end of shift made with the shift number I’m using sql 2000 server, my sql query in query analyzer doesn’t want to work I’ve tried two queries but no luck help will be much appreciated.

(1rst)

SELECT UNIT_ID,TRANSACTION_SHIFT_NUMBER,MAX(SHIFT_END_DATE)

FROM SHIFT_DETAILS

WHERE UNIT_ID IN ('16250','16251','16253','16254','16255')

GROUP BY UNIT_ID

(2^nd)

SELECT SD.UNIT_ID,TRANSACTION_SHIFT_NUMBER, (SELECT MAX(SHIFT_END_DATE)

FROM SHIFT_DETAILS AS SD WHERE SD.UNIT_ID = SD.UNIT_ID)

AS SHIFT_END_DATE FROM SHIFT_DETAILS AS SD

WHERE UNIT_ID IN ('16250','16251','16253','16254','16255')

Query to calculate percentage

Tue, 24 Nov 2009 08:14:51 Z

How can I calculate percentage in a query?
I have data like (just an example),
Table1(Sno, SName, SAddress, SRace,SItems)
Race can have Muslim, Christian, Hindu, Jew etc, where as SItems will have the number of items they bought..
Result that I want is:
S.no SRace Count_of_SItems Percentage
1 Hindu 5 25
2 Muslim 5 25
3 Christian 5 25
4 Jew 5 25

The percentage is taken from the total count of SItems.

1. How can I calculate the percentage?
2. How can i check the total number of records in a table, at a perticular date?

Regards,
N_SQL
Unfortunate is he who cannot gain a few sincere friends during his life
...and more unfortunate is the one who has gained them and then lost them (through his deeds).

SQL Server DBA Training

Tue, 24 Nov 2009 19:42:52 Z

Hi All,

I am very much interested in getting into SQL DBA Job. I took some sort of training for 2 weeks. That is not good enough for me. Could any one help me how I can gain more knowledge. What to read . Where to read etc.

I would appreciate your help in this matter.

Thanks,
naidu

MCITP 2005 Still Worth ?

Tue, 02 Jun 2009 07:22:21 Z

Hi,

I've experienced SQL Server 2005 db admin for about 2 years and now I'm starting to work on implementation and db admin in SQL Server 2008.

Does anyone know when is the SQL Server 2005 certification expiring ?

If it's still worth, I'm considering taking MCITP 2005 plus an upgrade to MCITP 2008. 3 exams for 4 certs.

What's your advice ?

TIA...

efficient way to delete the duplicate records

Tue, 24 Nov 2009 08:45:43 Z

Hi,

    I want to remove duplicate email records from 37 million table having duplicate emails among the other 36 columns.I have 3 queries for that , But Iam not getting which one is efficient.
So please suggest me the efficient method from below 3 queries.

Thanks in advance..........

---------------------------------------------------------------------------------------------------------------
--Inserting into new table using group by

insert into [newtable]
select * from [consumer]
where id in(select max(id) from [consumer]
                  group by email)
---------------------------------------------------------------------------------------------------------------
--Deleting directly from table using self join

DELETE FROM [consumer]
WHERE [RID] IN
(
SELECT a.[RID]
FROM [consumer] a,[consumer] b
WHERE a.[RID]!= b.[RID]
    and a.[RID]< b.[RID]
    and a.[Email]= b.[Email]
)

----------------------------------------------------------------------------------------------------------------------
--Inserting into new table using Partition by

with EmailRecords as (
select
    row_number() over (partition by Emailaddress order by Id desc) as RowNumber
    -- Assuming Highest Id is most recent
    Id,
    FirstName,
    LastName[,...]
from  [consumer]
)
insert into NewTable
select Id,FirstName[,...] -- Note, do not include RowNumber
from EmailRecords
where RowNumber = 1;

/*
After running this, you can drop the original table then rename [NewTable] to the original table name.
*/

---------------------------------------------------------------------------------------------------------------------------------

How to retrieve a table from another database

Wed, 25 Nov 2009 01:48:09 Z

Hi All,

I have a question about retrieving a table from another database. I've created a view called CS_View in db_1 which is as followed:

create view [dbo].[CS_View] as
SELECT source,
description
from source

How do I retrieve the source table from another database such as db_2.

Thank you

CC

This person has no signature.

How do I store a file path as a hyperlink in a table?

Tue, 24 Nov 2009 20:55:54 Z

Hello.

In Microsoft Access I can store hyperlink paths to external documents.

In SQL Server 2005, I'm not able to find the equivalent. How does one store a file path as a hyperlink in a SQL Server database table? Does one just create a column and set the datatype to varchar(max) and store the file path as text, and have the front-end application read that path and open the file? Or is there (ok, this sounds too simple) a hyperlink on/off setting in SQL Server?

How to turn on MARS from MS Sql Server Management Studio?

Tue, 24 Nov 2009 21:23:59 Z

Same as title.

Put all my eggs in one basket, or not?

Thu, 19 Nov 2009 17:14:20 Z

Hello.

I'm not sure if I should post my question to this form. If you have any suggestions for other forums, please let me know. Please accept my apology if my post is in the wrong place.

I am a biologist asked to implement SQL Server 2008 and build an environmental information system for a major client. I am also preparing for Microsoft certification in implementing and managing SQL Server, and want to progress to DBA. I feel pretty comfortable using SQL Server.

I've got a manager who is pressing to put all his "eggs in one basket". In other words, migrate several different Microsoft Access databases with data from multiple clients into one single centralised database in SQL Server. This manager knows very little if anything about managing databases, and also likes to micromanage people! :-/

Putting one's eggs all into one basket may seem attractive to some, and there may be several advantages to doing so. However, I'm not convinced this is the approach to take, especially when data belonging to multiple clients end up all in the same system and need to be served out to those clients separately.

Does anyone have any arguments for (pros) the centralized (all in one basket) approach?

What are the dangers/cons of this approach?

Sincerely,
Rupertsland, Canada

SQL Svr Standard Edtn 2005 Win32 Sngl MVL 1 Proc purchase

Fri, 10 Oct 2008 01:55:05 Z

I want ot purchase the SQL Server 2005 Standard Edition for XP. My sales team provide the purchase order having the sw name as SQL Svr Standard Edtn 2005 Win32 Sngl MVL 1 Proc. Is it correct ?

Cannot update "Securiry update for SQL server 2005 service park 2 (KB948109)

Tue, 24 Nov 2009 09:40:04 Z

Whenever I am updating my programs, the "Security update for SQL server 2005 service park 2 (KB948109) always fails. That prevents me from viewing some installed downloaded programs

Changing license key in SQL Server 2005 Standard Edition 64-bit

Mon, 28 Apr 2008 14:00:00 Z

Hi,

I need to install Microsoft SQL Server 2005 Standard Edition 64-bit running on Windows Server 2003 R2 Standard Edition 64-bit. Instead of installing it on every single machine I thought of installing it on one of them, updating it with all the necessary updates, creating a ghost image of the updated system and database and copying the image on all the other machines.

After doing it I however need to update both the system and SQL Server license keys. And there comes my question whether one can change the SQL Server license key after the installation??

Thanks in advance

if statement within a SELECT to change SUM totals?

Mon, 23 Nov 2009 15:02:26 Z

I have a VERY simple SELECT statement which (amongst other things) gets a SUM from a total column in an orders table.
I group it by a datepart Week so I get a total per week..

all works well..
however now I need to edit this so dependant upon the individual orderdate I divide the individual total by one of three numbers
(I'm basically working with GROSS figures and need to re-work them back to NET, but here in the UK, the VAT rate will be changing soon as did again about 13 months ago..)

here is my existing Statement:

SELECT SUM(Total) AS WeekRetailTotal, COUNT(*) AS MonthRetailOrderNo, DATEPART(wk, OrderDate) AS SalesWeek

FROM dbo.Orders_Retail

WHERE (account = @Account) AND (YEAR(OrderDate) = @YeartoUse) AND (OrderStatus <> 'Deleted') AND (PayStatus <> 'Pending') AND 

(OrderStatus <> 'Refunded')

GROUP BY DATEPART(wk, OrderDate)

That sum total I need to change so that if the ORDERDATE field is before Dec 1st 2008 then I divide the total by 17.5, between DEc 1st 2008 and Dec 31st 2009 divide by 15, and then after Dec 31st 2009, back to divide by 17.5

Any ideas how to do this?

thanks!! for any replies

Mtm81

SQL 2008 Downgrade Rights - Clarification

Fri, 20 Nov 2009 18:57:20 Z

Hi there,

I was just wondering if someone could explain to me how the SQL 2008 downgrade works. I guess the specific questions I have are:

1. Is there a cut off purchase date for SQL 2008 that includes downgrade rights?
2. In the 2008 licensing overview it states:

"If you require SQL Server 2005 for existing solutions, you can still acquire additional licenses by taking advantage of the SQL Server 2008 "downgrade rights." The downgrade rights enable you to purchase server plus device CALs, server plus user CALs, or processor licenses for SQL Server 2008 and install and use the previous version for a reasonable period of time."

What is considered a "reasonable" period of time?

Question on Table Partitioning

Fri, 20 Nov 2009 17:32:01 Z

We have a database that is currently > 25Gb and is getting too large. We have two tables that comprise most of the size and are looking into ways to archive off some of this data to another database thus allowing us to shrink the main database and make is smaller. Someone suggested we look into table partitioning to address this. However, from reading the SQL docs, it sounds like all partitions must be in the same database. If this is true, then partitioning a table won't really make the database any smaller.

Am I correct in assuming that table partitioning won't really make our data base any smaller?

Thank you for any suggestions.

-Dave

MSSQL 2005 License

Tue, 24 Nov 2009 07:08:24 Z

Last two weeks back we have purchased one MSSQL 2008/2005 License through SHI VENDOR.

We have MSSQL 2005 Software in place. when we installing the MSSQL 2005 we are not able to update the new license product key.

The existing product key located in the time of installation. We need to update the new license key in the MSSQL 2005.

Kindly assist me for this license changes.

SQL Developer Qualifications

Sun, 22 Nov 2009 07:56:44 Z

To be a good SQL develpoer what are the things one should know