SQL Server is a relational database management system from Microsoft.
49
votes
20answers
17k views
Stored Procedures a bad practice at one of worlds largest IT software consulting firms?
I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...
11
votes
5answers
2k 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 ...
10
votes
13answers
899 views
Do SQL Devs create SQL queries using SQL Query Designers?
I was just curious if SQL Devs write their code freehand or do they make use of the visual query designer to generate queries? In the majority of the cases, the query designer can create most of ...
9
votes
3answers
4k 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 ...
8
votes
3answers
359 views
How do you handle constantly changing database dimensions?
For the last two months or so I have been looking for solutions or practices to handle release management within databases. I'm looking for what people view as the best process for handling this.
We ...
7
votes
10answers
1k views
Do Microsoft Certifications matter? [duplicate]
Possible Duplicate:
Are certifications worth it?
I'm curious what experience others have had, both from the perspective of an employer and an employee on Microsoft Certifications.
I'm kind ...
7
votes
7answers
916 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 ...
7
votes
4answers
228 views
How best to handle database refactoring within a team?
We are currently usign a roll-forward approach to DB changes, akin to Migrations, where each developer creates and checks in a script that promotes the latest version of the DB to a new state. ...
7
votes
5answers
572 views
Visual Studio 2010 SP1 Performance
I've noticed since installing Visual Studio 2010 SP1 that I'm having huge performance issues. It will randomly freeze up on me quite a bit.
I had no performance issues with Visual Studio 2010 before ...
7
votes
4answers
415 views
Can anyone recommend coding standards for TSQL?
We've long had coding standards for our .Net code, and there seem to be several reputable sources for ideas on how to apply them which evolve over time.
I'd like to be able to put together some ...
7
votes
1answer
277 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). ...
6
votes
9answers
2k views
Foreign key restrictions -> yes or no?
I would like to hear some”real life experience” suggestions if foreign key restrictions are good or bad thing to enforce in DB.
I would kindly ask students/beginners to refrain from jumping and ...
6
votes
5answers
305 views
Anti Identity Column
I recently came across some code which generates an identity value for a key:
DECLARE @ID INT;
SELECT @ID = MAX(ID) + 1 FROM Person;
INSERT INTO [Person]
([ID], [FirstName], [LastName])
VALUES
...
6
votes
6answers
4k views
When should I use the XML data type in SQL Server?
When should I use the XML data type in Microsoft SQL Server?
6
votes
2answers
285 views
Should I Do Calculations in T-SQL or Program?
I am creating a stored procedure that is logging some data. The data ultimately needs to end up in 2 tables. The incoming data is coming from a JSON string containing 15 parameters, and the data is ...
