SQL Server is a relational database management system from Microsoft.

learn more… | top users | synonyms (1)

2
votes
1answer
221 views

Does the deprecation of mysql_* functions in PHP carry over to other Databases(MSSQL)?

I'm not talking about MySQL, I'm talking about Microsoft SQL Server I've been aware of PDO for quite some time now, standard mysql functions are dangerous and should be avoided. ...
2
votes
4answers
2k views

We are moving an Access based corporate front-end into a Web-based App

We have an enterprise application with a front end written in Microsoft Access 2003 that has evolved over the past 6 years. The back end data, and a fair amount of back-end logic is contained within ...
0
votes
4answers
3k views

SQL Server Management Studio Show last executed query

I am looking for a way for SQL Server Management studio to show me the last SQL query that was run. For example, when I make modifications to a table in the designer mode, I will eventually want to ...
2
votes
2answers
904 views

SQL Server 2000 vs 2008 Express? [closed]

Due to not wanting to pay licenses my company is still using SQL Server 2000 for new projects. This is very limiting for multiple reasons. I'm wondering what are the limitations of using SQL Server ...
7
votes
2answers
2k views

Best method to implement a filtered search

I would like to ask you, your opinion when it comes to implement a filtered search form. Let's imagine the following case: 1 Big table with lots of columns It might be important to say that this SQL ...
3
votes
3answers
428 views

Why should I add CHECK CONSTRAINT?

Following is a table creating script created by Entity Framework using the model shown in http://codereview.stackexchange.com/questions/14077/is-it-proper-tpt-inheritance. In this script, there are ...
3
votes
3answers
2k views

Best practices: Ajax and server side scripting with stored procedures

I need to rebuild an old huge website and probably to port everyting to ASP.NET and jQuery and I would like to ask for some suggestion and tips. Actually the website uses: Ajax (client site with ...
7
votes
1answer
648 views

Are there tools that do automated validation of database standards?

I'm looking for something akin to FxCop, but for databases. Basically, I want to have a tool where I configure my database standards (naming conventions, field types, or more complex custom rules). ...
1
vote
3answers
406 views

Is an API in C++ a better alternative to computing directly in SQL?

I need to perform large amounts of computations on data storerd in a busy Microsoft SQL server. Would it be faster if I retrieve the data from the server, perform the computations locally in C++, and ...
3
votes
5answers
577 views

How do you keep track of the meaning of your SQL fields?

The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data. I use SQL ...
13
votes
3answers
28k views

Why do we need to put N before strings in Microsoft SQL Server?

I'm learning T-SQL. From the examples I've seen, to insert text in a varchar() cell, I can write just the string to insert, but for nvarchar() cells, every example prefix the strings with the letter ...
0
votes
2answers
175 views

How should I handle using two databases with a legacy PHP application?

I have a legacy PHP application that was written in 2004 and uses MSSQL as a database backend. At this stage MSSQL is still supported by PHP but only just via a Microsoft driver. I have looked at ...
-1
votes
3answers
280 views

How to manage and improve web application with 50 customers?

First of all, sorry for my English. We've developed a Web Application using ASP.NET and Sql Server. We've started selling it and of course are still continually improving and developing it. The ...
0
votes
3answers
1k views

Is this overkill? Using MDX queries and cubes instead of SQL stored procedures

I am new to Microsoft's SQL Server Analysis Services Cubes and MDX queries. Where I work we have a daily sales table in SQL Server 2005 that already contains an aggregate of sale information per ...
2
votes
4answers
197 views

.NET app - Should we use SQL Server and duplicate some reference data from an external Oracle DB? Or use Oracle and have a DB link?

We're looking to migrate some existing Excel/Access processes into a new system which will provide the users with a Silverlight frontend to run and view the reports instead of using MS Access. The ...
2
votes
5answers
3k views

SQL Strings vs. Conditional SQL Statements

Is there an advantage to piecemealing sql strings together vs conditional sql statements in SQL Server itself? I have only about 10 months of SQL experience, so I could be speaking out of pure ...
2
votes
5answers
2k views

I feel unprepared to start my first job out of college… how can I improve? [closed]

I just graduated from university with a degree in Computer Science/Engineering and was fortunate enough to land a job working in the pharmaceutical industry as a developer. My title is System ...
3
votes
5answers
396 views

New application development - Use existing database or create a new one?

A Client has a huge Windows Application running on a Database. This client wants you to develop an "Express" version of this application, including only, let's say, 20% of its features. This Express ...
3
votes
6answers
897 views

How to include database changes during application publish

I am maintaining a WinForms application, which talks to a SQL Server database. Sometimes I have to change database schema (for example to alter a sql procedure or add new one). For this purpose I have ...
5
votes
3answers
774 views

Overloaded high transaction SQL Server database Solutions

The current sql server database is overloaded and many transactions are failing. The powers that be have a proposed solution to build a separate database to handle/store transactions and then ...
2
votes
4answers
1k views

At least one database view per database table-Is this good or bad design and why?

We are building a Windows Mobile based application to interface with a customer's existing web application. We are reading and writing data to the customer's SQL server 2008 database. The customer ...
5
votes
5answers
746 views

Is realtime validation of username good or bad?

I have a simple form for the user to sign up to my site; with email, username and password fields. We are now trying to implement an ajax validation so the user doesn't have to post the form to find ...
2
votes
1answer
525 views

How to deal with transactions when creating a database connection for each query

In line with this post here I am going to change my website to create a connection per query to take advantage of .NET's connection pooling. With this in mind, I don't know how I should deal with ...
15
votes
2answers
13k views

Creating database connections - Do it once or for each query?

At the moment I create a database connection when my web page is first loaded. I then process the page and run any queries against that conection. Is this the best way to do it or should I be creating ...
2
votes
3answers
650 views

Designing a large database with multiple sources

I have been tasked with redesigning, or at worst optimising the structure of a database for a data warehouse. Currently, the database has 4 other source databases (which is due to expand to X ...
9
votes
7answers
4k views

What is the preferred tool/approach to putting a SQL Server database under source control?

I've evaluated RedGate SQL Source Control tool (http://www.red-gate.com/products/sql-development/sql-source-control/), and I believe that Team Foundation Server 2010 offers a way to do this as well ...
2
votes
1answer
273 views

How to swap out a DB from MySQL to SQL Server in a multiple large projects?

Is there a sane way / best practices way to swap out a DB from MySQL to SQL Server in a multiple large projects? Some of the projects are ASP projects, some of them are windows services, some are ...
0
votes
1answer
119 views

migration and interoperability

A large system has already been done in visual fox pro. They want to add more requirements to a module and make some changes to the system.At the same time they are thinking about migration to .net. ...
5
votes
4answers
249 views

Putting audit functionality into the database

Our database does not have any audit functionality. It does not records who inserts the record or who who changes it It does not keep a history of the changes made Nothing can be restored if ...
0
votes
2answers
210 views

What can I do to help users create self-service reports?

I work using Reporting Services 2008 and I'm constantly creating ad-hoc reports. We'd like to use PowerPivot on Sharepoint but we're stuck on Sharepoint 2007. Using easy reporting software like ...
5
votes
1answer
1k views

Designing a scalable and robust retry mechanism

Backstory I have an Messaging Server Application that is responsible for brokering/proxying calls made from an Application Tier to numerous external services. The purpose of this application is to ...
7
votes
4answers
21k views

Best practice to query data from MS SQL Server in C Sharp?

What is the best way to query data from a MS SQL Server in C Sharp? I know that it is not good practice to have an SQL query in the code. Is the best way to create a stored procedure and call it ...
2
votes
2answers
1k views

How to gauge a person's ability to write SQL queries? [closed]

If I am a Java certified programer, by seeing that certificate people can say I have good knowledge on Java in a snap. Is there any similar certification to know if a person can write good SQL ...
3
votes
1answer
144 views

Is there another name for Sql Azure's programming language?

According to this page on MSDN the sql language used on Sql Azure is called transact-sql (the same as on sql server). But is this the only way to refer to programming on Sql Azure? The Sql Azure ...
1
vote
2answers
280 views

Are there any advantages of using separate RDBMS for reports?

My production database is SQL Server 2008 R2 Express. It has limited features and I am testing it in a production environment. To better handle reporting queries in a highly concurrent environment, I ...
13
votes
5answers
4k views

Version Control with SQL Server

I'm starting a new project and using SVN (with Tortoise) as my Version Control System. I was wondering if it was possible to also maintain a SQL Server Database using the same system. I'd want to ...
2
votes
1answer
791 views

What should we include in SSAS cube design documentation?

What should we include in a SSAS cube design documentation? This is the initial phase of the document. I have included: data models, facts, dimensions, surrogate keys, hierarchies and levels ...
7
votes
2answers
5k views

Can SQL Server and Mongo be used together?

We have a large news-oriented site that has high web traffic. The architecture is your often seen DB - Repo Layer - Services Layer - Asp.Net MVC. The problem that we've been seeing is around read ...
4
votes
3answers
7k views

Which is better : Storing/retrieving images on/from SQL server or in a directory on server

I am working on a project in Asp.net MVC and need to work with images. There is an SQL database with a Product table. Every product in the table will have it's own image. I have two ways to do this : ...
5
votes
4answers
339 views

Multiuser System With Encrypted Database

I am currently developing a hosted solution in ASP.NET using MVC3 and Entity Framework. This product will then be made available to a number of clients as a hosted solution. As the data stored by ...
3
votes
3answers
2k views

How to reach to the advanced level in SQL? [closed]

I think I have a good grasp of SQL and the most features it has, but sometimes when I've done some more advanced Reporting Services a fellow developer has helped me with some stuff and when I open ...
0
votes
2answers
2k views

Server OS/Software Requirements For asp.NET Framework 4.0

The Background: Me and my colleague are opening a new website design & development company. We have designed and implemented a website on Microsoft Visual Studio 2010 using Web forms in .NET ...
0
votes
2answers
124 views

Local and cloud editions?

I have a .NET web server application I'm building that I plan to host at a .NET cloud hosting platform, like AppHarbor with SQL server. It will be used by multiple small groups of people to record and ...
1
vote
3answers
7k views

Sequel vs S-Q-L [duplicate]

Possible Duplicate: What's the history of the non-official pronunciation of SQL? I hear it every so often, "In sequel server...", and for some reason I cringe every time. Maybe it's ...
0
votes
4answers
866 views

Comparing Visual Foxpro with .NET

I used Foxpro 2.6 a decade ago. In my present company, few new projects are being developed in Visual Foxpro 9.0 and few projects are on .NET platform. From time-to-time I notice how Visual Foxpro is ...
0
votes
2answers
2k views

Using Visual Foxpro DBF with ASP.NET as opposed to SQL Server

I work in a small software company where my boss is a great fan of Visual Foxpro. We are working on an ASP.NET project but my boss is insisting to use Visual Foxpro DBF instead of SQL Server. I want ...
6
votes
4answers
2k views

Should “tags” be an nvarchar field in a table, or should it be another table altogether?

I am building a photography website and I want to allow the user to put tags on their photos for easy searching. But I'm not sure if I want the tags to be an nvarchar field in each picture and then ...
1
vote
2answers
902 views

Which database to prefer while developing a WPF medical inventory system?

I have a project to develop an inventory system for a medical shop. Till date, I confronted simple requirements which were fulfilled with XML as the backend db. My interaction knowledge with XML is ...
3
votes
2answers
421 views

Pros/Cons for a Data Structure covering multiple databases?

I'm about to extend a system containing two separate systems. Or domains, if we see the system as a domain level. Today One domain is used internally. The other is public, which means it is more ...
7
votes
3answers
325 views

Using a standard localised data cryptography pattern with an ASP.NET MVC3 application

I have been given the task to rejuvenate an existing Human Resources application from Access into ASP.NET. This is a strictly internal application, and I have no problems developing it within our ...