Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.
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 ...