All Questions
Tagged with sql-server stored-procedures
16 questions
1
vote
2
answers
82
views
How to write robust or alternative to TSQL data processing routines in SqlServer?
My company has a workflow that involves ingesting huge amounts of raw data from external sources into SqlServer and then interpreting and weaving that data into our own application tables. This ...
- 587
3
votes
5
answers
8k
views
How to do versioning for stored procedure?
Is there any way to create versioning for stored procedures? I have created an API which fetches data from a database using stored procedures. This API is being consumed from a mobile app. I released ...
- 177
1
vote
1
answer
266
views
Multiple stored procedures or 1 with parameter
I need some advice...
I started working at a financial business world recently.
Looks like the DB architect uses auto generate function to create stored procs. At the end, we have way too many procs ...
- 13
1
vote
2
answers
2k
views
Encrypt data in code or stored procedures?
I'm working on a Web App where the data is quite sensitive and is required to be encrypted before it is stored in the database.
Now there are two ways through which I can achieve this:
Encrypt data ...
7
votes
1
answer
2k
views
Determining the best way(s) of adding unit tests to a large project that makes good use of stored procedures
We work on a fairly large casino/gaming/wallet/lottery platform. It's a turn-key application that is currently in use by 4 clients, and soon to be much more. I've made some bullet points regarding the ...
- 269
22
votes
6
answers
20k
views
When should I use stored procedures?
If I have all my business logic in code and make use of Entity Framework, in what situations (if any) would I be better moving some business logic to a stored procedure, instead of keeping it all in ...
- 493
1
vote
2
answers
1k
views
How should I handle Stored Procedure parameters that need to be the same length as a column?
I'm writing a lot of stored procedures for a SQL Server database that take an id or code that is a CHAR instead of an INT. Most of these haven't changed size in a long time, but when a customer wants ...
- 721
1
vote
1
answer
3k
views
Generating reports from large datasets
I'm working on an CRM type application(.NET, SQL Server) that needs to generate reports from large datasets, millions of database rows in a dozen different tables with a lot of aggregation and logic. ...
- 174
2
votes
5
answers
907
views
How does a query execution plan affect query execution?
I have read some articles on SQL Server query optimization. The point I get is SQL Server generates a query execution plan for each stored procedure when it's executed for the first time. Those ...
- 683
3
votes
2
answers
324
views
Stored Procedure performance
I'm working on upgrading an application written by a former developer at my work and I've been converting all the SQL queries in the code into Stored Procedures. I'm doing this with the idea that it ...
- 173
1
vote
1
answer
578
views
Is it a good practice to write distinct queries in a single stored procedure based on input parameters
I am going through the stored procedures written throughout our project and see that multiple distinct queries are written inside a single stored procedure and are called by passing different values ...
- 904
2
votes
2
answers
6k
views
A CLR SQL Server Stored Procedure calling an ASP.NET Web API
We are developing a big system with SQL Server database, ASP.NET Web API 2.2 services and another external services.
We need to load more data on a table while we process the current data on it. To ...
- 253
-1
votes
2
answers
2k
views
Storing Dates & Times in SQL [closed]
I have a tool that I am working on which allows people to create meetings. They can select the Date, Time & Timezone that this meeting is occurring in.
I need to determine the best way to store ...
- 109
0
votes
1
answer
1k
views
Advanced Search Stored procedure
So I am working on an MVC ASP.NET web application which centers around lots of data and data manipulation.
PROBLEM OVERVIEW:
We have an advanced search with 25 different filter criteria. I am using a ...
- 279
3
votes
1
answer
3k
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 = "...
- 131