SQL Server is a relational database management system from Microsoft.
1
vote
0answers
29 views
Write data to SQL Server directly from BizTalk or use external service?
An external source will be sending us XML data that BizTalk will pick up and transform into an internal schema. We need this data to be loaded into a SQL Server database as we're going to expose some ...
2
votes
1answer
69 views
Is it okay to convert dataset from stored procedure to IEnumerable
So, I am working on a project with a team and we are using Entity Framework. We basically want to use linq to entities, and not use stored procedures. I use quite a bit of lists and IEnumerables and ...
1
vote
1answer
115 views
Table scaling with partitions or with separate databases?
Let's say I have a table (let's call it BigTable) which could experience 5,000,000 INSERTS per day (with possibly just as many SELECTs). Each row inserted is about 50kb.
These daily INSERTs are ...
1
vote
1answer
19 views
Multiple Display of a Document and persist each viewer change in a single document
i have a scenario where i have to make available a document for viewing and editing to multiple users, the users can edit and view the document at the same time. Now the problem arises here if for ...
3
votes
4answers
397 views
Better way of storing key-value pairs in the database?
I have a C#/SQL Server program that sometimes needs to store data. The data could be a response from a web service, a result of a database query, or any number of other things. There's no way of ...
2
votes
2answers
101 views
Scalability: How does splitting a database table work on different replicated SQL Servers?
I would like to know more about the general concepts behind dividing data of a database into different servers. For example, suppose I have a SQL Server database which has a massive table. Assume one ...
4
votes
1answer
128 views
Algorithm to denormalize database
I have built a QlikView script generator (QVS), that can be used to generate large script files for data imports from SQL Server to QlikView.
QlikView does not like 'fully' normalised database ...
0
votes
3answers
147 views
Using xml datatype to store a “shopping cart”
For my final project in school we have to develop an online shop. This shop should have a cart where items can be placed whether or not you are logged in. If you log out the cart shouldn't empty and ...
0
votes
2answers
159 views
Idea to develop a caching server between IIS and SQL Server
I work on a few high traffic websites that all share the same database and that are all heavily database driven. Our SQL server is max-ed out and, although we have already implemented many changes ...
-1
votes
1answer
348 views
How to create computed column in SQL Server 2008 R2 [closed]
I have a SQL Server 2008 R2 database. This database has two tables called Pictures and PictureUse.
Picture table has the following columns:
Id (int)
PictureName (nvarchar(max))
CreateDate ...
0
votes
0answers
41 views
Moving sql database [closed]
I need to move the sql database to a new server without changing the app that uses that database, how can i do this easily without affecting the users ?
-2
votes
1answer
144 views
What architecture to use? [closed]
I work at a small software engineering company. We are facing some issues regarding maintainability and speed with our applications. Currently, we have the following situation:
For each of our ...
3
votes
4answers
210 views
What is the most effective order to learn SQL Server, LINQ, and Entity Framework?
I am trying to get some advice on what order I should learn about SQL Server, LINQ, and Entity Framework to be able to better work with ASP.NET Webforms and MVC.
From what I've been able to learn so ...
2
votes
3answers
434 views
Storing Attendance Data in database
So i have to store daily attendance of employees of my organisation from my application . The part where I need some help is, the efficient way to store attendance data. After some research and brain ...
1
vote
3answers
127 views
Is it more difficult to upgrade your certification from SQL Server 2008 to 2012 than to get it from scratch? [closed]
I was wondering about the new MCSA certification on SQL 2012 and how it seems to be more difficult to upgrade your certification from 2008 to 2012 than to get the 2012 from scratch.
Reason I think ...
3
votes
0answers
203 views
Calling MSSQL stored procedure from Zend Controller ? Any other approaches?
MSSQL and DB, Zend as PHP Framework,
I am using this way to call SP with I/P Parameters and to get O/p Parameters.
It seems I am writing SQL code in PHP.
Any other good approaches?
$str1 = ...
2
votes
1answer
172 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
346 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
894 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
444 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 ...
5
votes
2answers
227 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
248 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
876 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 ...
4
votes
2answers
138 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
293 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 ...
5
votes
4answers
388 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 ...
9
votes
3answers
3k 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
3answers
533 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
141 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
1k 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
723 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
242 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
433 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
280 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 ...
1
vote
4answers
312 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
629 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
3answers
310 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 ...
7
votes
7answers
753 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 ...
-1
votes
1answer
243 views
Shared Data Source name error underscore characters added
The name of our shared data source in RS (report server) is "AF1 Live Database" (no underscore characters - just spaces between words) and is the same in report builder in VS. However, the following ...
2
votes
1answer
123 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
90 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
192 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
141 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 ...
3
votes
2answers
599 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 ...
5
votes
4answers
7k 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
502 views
How to gauge a person's ability to write SQL queries?
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
110 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
174 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 ...
11
votes
5answers
1k 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
373 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 ...
