Tagged Questions
3
votes
1answer
38 views
Convert SQL Server 2012 SSIS package to 2008
I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state.
Is there a way to convert the 2012 packages to ...
-1
votes
0answers
34 views
Abot SQL Server's Tabular [closed]
Goal:
The goal is to view if SQL server 2012 tabular and its in-memory ability with can be used in relation to PowerView, Excel and Reporting service at the same time. No different instance shall be ...
1
vote
1answer
51 views
Can I use Try_Cast to give me a query result column with different datatypes?
I have a column that is varchar(max). It contains mostly valid XML. But sometimes it has invalid xml (that I still need).
I am trying to make a view for this table that allows the value to display ...
1
vote
1answer
60 views
Restoring SQL Server 2012 database onto 2008
I am trying to restore a SQL Server 2012 database after I set the compatibility level to SQL Server 2008 by following the instructions as listed on: ...
3
votes
1answer
39 views
tempdb logs on same drive as tempdb data or with other logs?
For many reasons I only have 3 hard drives (RAIDed and in an Always-On AG) for all my database files:
D: Data
E: Logs
F: Tempdb
Should the tempdb log file go on F: with the data file(s) or on E:?
...
1
vote
1answer
60 views
Paging in SQL Server 2012 vs. previous versions
I have used lot of paging code in SQL Server 2008. The format is
With CTE(
-- SQL With RowNumber
)
-- SELECT ALL Page N
This is working fine. But I have heard that SQL Server 2012 has better ...
1
vote
1answer
43 views
How can I identify the number of times a View is called in SQL Server?
How can I identify the number of times a View was called in SQL Server?
I am looking for an answer that is similar to this below which shows how it can be done for stored procedures.
How can I ...
2
votes
2answers
77 views
Identity proceeds as normal, but with a leading 10…?
So I noticed a very strange thing when tinkering with my database.
I had just inserted a row which was ID 47, then after inserting some more, I realised that somehow my Identity had skipped all the ...
6
votes
1answer
101 views
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR
We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
1
vote
1answer
91 views
import csv data stored in a blob column
Here's what i need to do:
Users will upload CSV files into SQL Server 2012 blob column
Each night, i would like to take each file and import the data into table
I will have 2 web sites using the ...
1
vote
1answer
122 views
Backup stored procedure for full, differential and log backup
I wrote a simple stored procedure for backing up FULL, Differential and LOG backup. This is my stored procedure:
Alter PROCEDURE BackupDB
(
@BaseLocation varchar(1024),
@BackupType ...
2
votes
2answers
50 views
How do I write backup procedure
I've read that a decent backup strategy would be:
1) Full backup weekly
2) Differential backups daily
3) Log backups every 5 minutes.
Now question is how do I write this stored procedure and create ...
4
votes
3answers
143 views
Backup strategies for zero data loss
I am working on one project and it has around 100K records. We can afford a downtime of 1 day but we need the data to be always available to us in latest state.
I've gone through two options:
1) ...
0
votes
2answers
55 views
some tips on setting up sql server database server
I am currently setting up a new sql server database server with databases. It is supplied by a third party company.
I need to request access for them around ports etc.
I would like to be able ...
4
votes
1answer
111 views
Query records that chain together based on date gaps
I have a table in SQL Server 2012 with the below simplified schema and I need to define a query that grabs the most recent record and then returns the chain of records that have less than 30 days of a ...
4
votes
2answers
239 views
Restore SQL Server database from .sql files
So we had an encrypted database that puked and killed our whole SQL Server setup. Sucks about our data, but we were smart enough to have our data structures / stored procedures / functions in Git
The ...
7
votes
1answer
213 views
selecting more fields causes catastrophic failure
I have a connection to a linked server from sql server 2012 to pervasive sql.
When I do select field1, field2, field3 from mytable everything works!
However, when I do select field1, field2, field3, ...
1
vote
2answers
165 views
Query Performance Tuning on a huge table
I have the following table Transactions. The table looks like this:
CREATE TABLE [dbo].[Transactions](
[TransactionID] [bigint] IDENTITY(1,10) NOT NULL,
[PlayerID] [bigint] NOT NULL,
...
0
votes
0answers
517 views
0x84BB0001 Error when installing SQL Server 2012. Could not create a handshake
I have hopelessly attempted to install SQL server 2012 onto my 64 bit Windows 8 machine.
The database engine always fails to install with error 0x84BB0001. Native reporting also fails, I reckon from ...
3
votes
1answer
107 views
sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Can someone explain to me what is the difference between collation sql_slovak_cp1250_ci_as vs Slovak_CI_AS?
I have a db set to sql_slovak_cp1250_ci_as and shared hosting supports only Slovak_CI_AS. ...
4
votes
2answers
278 views
SQL Server 2012 database backup successfully report but no backup file
I have created maintenance plan in SQL Server 2012. And every day, the maintenance plan should backup the database. There is no database backup file when I look in the folder where the backups must ...
3
votes
2answers
125 views
Does the Query cost in Sql Server account for buffering?
If I am comparing 2 queries by checking their relative "Query cost" as a high level indicator of performance, does the buffer status have any effect on the values shown in the execution plan?
1
vote
2answers
57 views
How much work actually happens on SSMS and how much on the server itself?
Suppose I run the following query:
declare @i integer
set @i=1
while @i < 2000000
BEGIN
insert into t1 (ID,DESC,date) values (@i%200,concat(NEWID(),newid()),GETDATE())
set @i = @i +1
END
Is the ...
1
vote
2answers
133 views
correct security and user setup for SQL Server database
I am currently on setting a sql server database on a database server. A front end web application running off a web server communicates to the database.
What is the best approach for setting up users ...
2
votes
1answer
35 views
In real terms, how much effect does a bad fillfactor have on performance?
There's a storm brewing, or maybe I should say firestorm. A customer has recently implemented SQL Server 2012 Always On but that's not the most important bit.
A list of fires to be put out has been ...
4
votes
3answers
935 views
Restrict update on certain columns. Only allow stored procedure to update those columns
I have sensitive price columns that I would like to have updated only through a stored procedure. I would like all code or manual attempts to alter values in these price columns to fail if it is not ...
1
vote
2answers
371 views
How to Export SQL Server Database To A File For Later Import To Different Computer
I'm using the Sql Server 2012 Import and Export data (64) i'm not sure what options i should be picking to do what i want. I just want to be able to export all the data in the database to a file which ...
2
votes
1answer
72 views
Question about new behavior of current connection combobox in SQL Server 2012
I have a question about the new behavior of the database selection combobox in SQL Server 2012 (Press Ctrl + U to move your focus to it). It seems that, unlike in SQL Server 2008 R2, clicking in the ...
2
votes
2answers
80 views
remote connection
Im trying to connect to a remote sql server using windows authenication. I'm using visual studio 2012 and going to a remote sql server 2012. I have already checked in sql studio that it is set up for ...
0
votes
1answer
129 views
AlwaysOn SQL Server setup questions
I just have a few questions regarding the setup of Always On HA, and Clusters. When you setup an AG, and it gets to setting up your IP address for the cluster how can i switch from using DHCP to a ...
3
votes
1answer
211 views
How to check connection string in SSMS2012?
I'm connected to database. I use db by Management Studio 2012 Express. Can I check connection string by click something in Management Studio?
8
votes
3answers
156 views
SQL Server query slow when paginated
I am seeing some strange behaviour with the following T-SQL query in SQL Server 2012:
select Id
FROM dbo.Person
WHERE CONTAINS(Name, '"John" AND "Smith"')
order by Name
Executing this query alone ...
1
vote
2answers
165 views
SQL Trigger to verify account, if not verified dont process stored procedure/transactions
Is there a way to create a trigger or function to check a user against the database and if not verfied, the following stored procedure is not ran. I would like this option for verification check ...
1
vote
1answer
83 views
Which should be used after messing up clustered index? Update statistics, Reindex or Reorganize
If I have a clustered single column index, e.g FooId in SQL Server 2008, 2012 and I know I have messed up the order of the rows to not have sequential order of the FooId column anymore, which ...
