Lab Sql

I have some problems with my query - it takes too much time (2636124 ms!): SELECT COUNT(*) AS '… Read more PostgreSQL: Count Query Takes Too Much Time

Setup I followed Universal App with SQLite example to add SQLite to my project; then to add the Ba… Read more How To Use SQLite In Windows (Phone) 8.1's BackgroundTask

I have the following query that retrieve the number of users per country; SELECT C.CountryID AS Cou… Read more Retrieving Top 10 Rows And Sum All Others In Row 11

I have the following query that retrieve the number of users per country; SELECT C.CountryID AS Cou… Read more Retrieving Top 10 Rows And Sum All Others In Row 11

I am creating a database where different properties of a single object are measured via different s… Read more Strategy To Map Multiple Filed In A Single Table To A Single Field In Another Table

I have a DBUnit test which runs OK, but is taking ages (4-5 mins) to create the entity manager fact… Read more Persistence.createEntityManagerFactory Takes Ages

I have a table Cost category: CREATE TABLE [dbo].[CostCategory]( [ID_CostCategory] [int] NOT NULL, … Read more Create Table And Get Data From Another Table

We are testing a proof of concept of our apps. We have a managed SQL Server instance on Azure that… Read more How To Force In-transit Encryption On Sql Azure Like On Regular SQL Server?

Is it possible to design a twitter like DB using SQL server? a DB that will ensure high scalability… Read more Twitter Like Model Using SQL Server/Azure Or Graph DB

I've got a mysql database with a table that has both a auto-increment primary key and unique st… Read more MYSQL: Getting Existing Primary Key When Inserting Record With Duplicate Unique Key?

I have to GROUP BY a column and if there are more than one entries for it, I need to display the on… Read more Group By A Column And Display The Value Of The Column That Matches The Condition

I have a table having structure as follows id cust_id target month year fiscal_ID 1 234 50 … Read more Quarter Year Wise Result Filteration In Sql

I have a table @ROOMS_BY_DEPA_KEY1 like this: DECLARE @ROOMS_BY_DEPA_KEY1 TABLE ( … Read more Update Table From UDF Results

This question continues from the previous solved question (much thanks to Vladimir Baranov), which … Read more SQL Server - CTE Recursive, Looping In Child's Data?

Hi I had developed a C# Budget application using SQL Compact and EF4, I created the EF model throug… Read more Entity Framework, SQLite And Lazy Loading

How can I add a filter which can trace sql statements for a particular table name? Solution 1: … Read more How To Profile For One Table In SQL Server?

I am getting the error from the application as following with SQL server 2005 'Transaction co… Read more Transaction Count After EXECUTE Indicates That A COMMIT Or ROLLBACK TRANSACTION Statement Is Missing - SQL Server 2005

I have Oracle query: SELECT index_name, table_name FROM user_indexes; Since user_indexes is Oracle… Read more Oracle User_indexes Translation To MySQL

I have an Excel source going into an OLE DB destination. I'm inserting data into a view that h… Read more SSIS: "Failure Inserting Into The Read-only Column "

Some of the scripts were migrate manually without using readyroll script. Now any new push to dev b… Read more Readyroll : Getting Error While Build Using VSTS : Drift Analysis: These Changes Will NOT Be Applied Because DriftOptionBlockDataLoss=True