SQL Server is a relational database management system from Microsoft. Use this tag for all SQL Server editions including Compact, Express, Azure, FastTrack and PDW.
0
votes
0answers
6 views
Sql Server Decimal Vs Float
I want to know why these two Data types are given in SQL Server. I want to know exactly where these Two data types Differs? Its so important for me because we are creating an Banking System where ...
0
votes
0answers
2 views
Caching user-specific proximity searches
The situation and the goal
Imagine a user search system that provides a proximity search from a user’s own position, which is specified by a decimal latitude/longitude combination. An Atlanta ...
2
votes
0answers
10 views
High CPU usage on SQL server - Slow queries.
Our MS SQL Server is using about 95% of the CPU-power.
After a server (hardware) restart, or a SQL-Service restart, the usage is 0% and slowly increases over the course of 1-3 days. Depending on how ...
0
votes
0answers
8 views
How to query against a mdf file I attached in SQL Server in Visual Studio?
Hell all,
I just attached a mdf file in SQL Server 2008, and everything is working correctly. Now I want to open visual studio, and query against the mdf file I just attached, is there a local ...
1
vote
1answer
10 views
Join Two Dataset In One SSRS Chart Report
i Have two data sets. First one dataset shows Total counts against each person and the Second one Dataset shows SLA breached counts against respective person. As before i used two charts for for the ...
-1
votes
1answer
31 views
handle unterminated string constant in javascript
When my sql server SP returning string with new line character and in my jsp I pass it to script function and display it in alert box it throws :
function sample(notes){
alert(notes);
}
Error:
...
0
votes
0answers
22 views
Multiple ASP.NET Membership roles in the same Website
In my MVC3 application I have ASP.NET Membership roles like - Manager, System Admin and Editor
I am using Windows Authentication for the website and I am adding the users in the Network to the ...
0
votes
0answers
29 views
How to learn find used memory(RAM) of any table in SQL?
I dont know it is possible or not ? I want to ask you guys.If possbile how to learn used memory for XXX table.Which table use max memory ? (SQL SERVER 2008 )
0
votes
0answers
10 views
Can't see the Site Settings option for SSRS 2012
I don't seem to have the Site settings option on my SSRS instance.
I have looked at numerous online suggestions including:
...
3
votes
2answers
22 views
Are Columns Not Selected in SQL Views Executed?
I wasn't able to come up with the right keywords to search for the answer for this, so apologies if it was answered already.
Consider the following SQL view:
CREATE VIEW View1 AS
SELECT Column1
...
1
vote
1answer
17 views
Data Table Sum Issue
I have a situation.
I have datatable that contains the Credit and Debit columns like this
Month Credit Debit
Sep 1422825 0
Oct 0 1422825
Oct 1695017.5 0
...
0
votes
0answers
19 views
DataBase not expanding [duplicate]
My database expanding not working. it's struck to me .
please see my problem with image: A transport-level error has occurred when receiving results from the server. (provider: Session ...
1
vote
2answers
22 views
MSSQL not matching phone numbers with spaces
I'm trying to write an SQL query for SQL Express that will look up a phone number from the client's database. The issue I'm having is that some of the numbers in the database have spaces in them, but ...
-2
votes
0answers
32 views
How to enter day then month then year without using arrows in date time picker
I am using the following event. But it should point to day for every new transaction.
private void dateTimePicker1_Time_Validating(object sender, CancelEventArgs e)
{
DateTimePicker dtp = ...
0
votes
1answer
58 views
A query to SELECT a number range
I am having the following problem.
I would like to select a currency value from a database which will act as a default value on the top result of the query (this part is already done and is not a ...
