Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.

learn more… | top users | synonyms

0
votes
0answers
4 views

How to capture Stored Procedure call using DMV or jobs in sql server 2008 r2?

Hi i am working on SQL Server 2008 R2, can somebody help me to collect actual stored procedure call and estimated time it took to execute that SP ?
0
votes
1answer
8 views

How to view data in table variables during debugging session in MS SQL Management Studio 2012?

I would like to debug a complex T-SQL script using SSMS 2012. I can run the script in debug mode and place breakpoints, as well as step through my script, but I can't see the values stored in my ...
1
vote
1answer
16 views

Unable to start service MSSQLSERVER on server (mscorlib)

I tried to restart remote sql server (2012 full) and I've got such error: How can I fix it? I cannot start sql server. Every time I try I get this message.
0
votes
2answers
29 views

Trouble extracting First and LastName from Full Name column

I am having FullName column and I am extracting the First Name and last name using the following query select SUBSTRING(FULL_NAME, 1, CHARINDEX(' ', FULL_NAME) - 1) AS FirstName, ...
0
votes
0answers
4 views

Need Info similar to Algebrized Tree in SQL Server 2012

In a database application I'll be executing a few SQL queries. But I also need some metadata from the query or the result. What I basically need is to know exactly where each field came from (Table ...
0
votes
0answers
8 views

Entering data into a staging area

I need to have a way to allow users to enter in data to my SQL 2012 database via a web form, (lets call it FormA). The catch is that the data they enter should not be available for general use until ...
0
votes
1answer
10 views

Deploy SSIS Packages developed using SQL Server Data Tools for Visual Studio 2012

So I have a suite of SSIS packages that we created using Visual Studio 2008 and are currently deployed on a SQL Server 2008R2 instance. However, I would like to upgrade these to 2012 via SQL Server ...
0
votes
0answers
16 views

Entity Framework 5 not executing queries on a remote server

One of my projects using Entity Framework 5 is acting very strange. If I run the application on the same machine as the SQL Server 2012 instance, everything works perfectly. But if I run the ...
0
votes
0answers
9 views

Querying a SQL Server database in excel

Sub ParameterQuery() Dim sSQL As String Dim qt As QueryTable Dim rDest As Range '--build connection string-must use ODBC to allow parameters Const sConnect As String = _ "Driver={SQL Server ...
0
votes
1answer
29 views

Grouping of Million Data Points slow

I have a simple table containing 2 float columns representing X and Y coordinates. A non clustered index is on each of those 2 columns. In this table there are about 5 million datapoints which I want ...
3
votes
3answers
66 views

Identity column value suddenly jumps to 1001 in sql server

I am using Sql server 2012(Denali). I just wonder why all identity column values starts from 1001 and so on. At the begining Identity column starts from 1,2 and so on and adding identity smoothly, but ...
0
votes
1answer
32 views

Correct way to select from two tables in SQL Server with no common field to join on

Back in the old days, I used to write select statements like this: SELECT table1.columnA, table2,columnA FROM table1, table2 WHERE table1.columnA = 'Some value' However I was told that having ...
-1
votes
2answers
21 views

Counting occurences within a range of my table (SQL SERVER 2012)

I have the following question when I try to sum the number of occurences within an specific time frame. Let's say I have the following table: Date | New 2013-01-01 1 ...
0
votes
0answers
7 views

Programming or Free Command Line Tool for Schema Comparison between vs2012 DB project and sql server 2012 target DB

In VS2012 there is a very useful feature "Schema Comparison" if SSDT 2012 is installed, which allows to compare schema between "the DB project in your solution" and the target SQL SERVER 2012 DB ...
0
votes
1answer
12 views

Split query results into 15 minute intervals

Hope you can help me with this one... I'm needing to do some analysis on some data stored in a SQL Server 2012 database. I've currently got the query splitting the results into 1 hour chunks, but I ...

1 2 3 4 5 115
15 30 50 per page