Tagged Questions
0
votes
0answers
7 views
How to manage primary key while updating [closed]
In the following table primaryKeyColumn is primary key.
To maintain the data history I always uses the values with WHERE condition(WHERE StatusColumn=1) And will set the StatusColumn to 0 if the data ...
0
votes
0answers
6 views
SQL, moving million records from a database to other database [migrated]
I am a C# developer, I am not really good with SQL. I have a simple questions here. I need to move more than 50 millions records from a database to other database. I tried to use the import function ...
0
votes
2answers
81 views
Using lucene and sql server togheter. Newbie needs directions [closed]
Basically the whole thing can be explained simply:
I need to index one or more SQL Server 2005 databases with lucene so I can search the various records.
I found a lot of examples and documentation ...
2
votes
4answers
315 views
Database is performing slow, even all the tables are having normalization
One of the interviewers asked me this question:
Tables are created with appropriate normalization rules, However the database is performing slow. [Ie.: The select, insert statements are taking ...
0
votes
1answer
103 views
Different ways to generate the latest int type primary foreign key in code
I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key in the other. The type of the keys is integer. Now I want to generate the keys in the code and assign ...
0
votes
1answer
205 views
Are there any SQL servers that support compiled queries?
Can SQL queries be compiled into byte code or equivalent to enhance performance?
I know that most database servers support prepared statements, but is that the same thing as compiling? Most ...
2
votes
1answer
196 views
JOIN vs. INNER JOIN and FULL OUTER JOIN
I know there is a difference between INNER JOIN and FULL OUTER JOIN, I can see it, but, what is the difference between the two following: JOIN ... ON... and INNER JOIN...ON... and still yet ...
3
votes
1answer
357 views
Rewriting C# Formula Calculations in T-SQL
We have a 3-tier application with a C# client that connects to a C# web service via WCF and requests data from a SQL Server database.
One feature in our application is a user-created form app in ...
0
votes
1answer
139 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 ...
0
votes
0answers
45 views
What is a solution in keyword trend analysis with a FreeText field in SQL Server 2008R2?
I am currently using a SQL Server 2008 db, where in a table, I have a freetext field defined.
I would like to perform some trend analysis on one field, where I would provide the base for the trend, ...
2
votes
3answers
137 views
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries.
The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
0
votes
2answers
178 views
Should I retrieve one large set of data to filter or smaller individual sets of data?
I have a company intranet that utilizes a similar set of data across many different pages and many different methods.
Speaking in generalities, is it closer to "best practice" to retrieve a large ...
4
votes
1answer
220 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 ...
1
vote
3answers
1k 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 ...
3
votes
1answer
510 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 = ...
