Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).
2
votes
0answers
105 views
Why does CREATE INDEX … WITH ONLINE=ON block access to the table over a period of minutes?
I have an existing table:
CREATE TABLE dbo.ProofDetails
(
ProofDetailsID int NOT NULL
CONSTRAINT PK_ProofDetails
PRIMARY KEY CLUSTERED IDENTITY(1,1),
ProofID int NULL,
...
2
votes
0answers
48 views
Can't get users default schema to change - SQL Server 2008
We are migrating from a SQL Server 2008 instance on a shared host to our own box. Our issue is we have a bunch of tables, procs and views that are prefaced with a schema (let's call the schema 'me') ...
2
votes
0answers
123 views
Cannot connect to SQL Server 2008 after updating the service pack
After updating, whenever I start the service of the server in configuration manager, it always stops then.
And I found the error in the log
2013-04-13 19:08:19.63 spid7s Error: 15174, ...
2
votes
0answers
51 views
merge replication too big
I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database.
for some reasons I keep the old data in the databse and set ...
2
votes
0answers
50 views
Date dimension changes between Test and Production Server
I have a cube deployed into a Test environment and Production environment. I've noticed something strange happen with the date dimension.
When deployed into our test environment, the Date Key comes ...
2
votes
0answers
91 views
Conflict handling, SQL Server 2008 R2 Peer to Peer
I have a Peer to Peer replication topology set up between two SQL Server 2008 R2 servers. I was doing some testing on fault tolerance and conflict handling. I have conflict detection enabled, and ...
2
votes
0answers
81 views
How to speed up SQL Server RIGHT JOIN on 100MM+ Records - use TVF?
I use a table insert to UNION a CTE of converting transactions to visits (converting or not) and then summarize the visit data (no details, just pages visited & txns completed) to get funnel ...
2
votes
0answers
63 views
Can the same database be log-shipping secondary and primary at the same time?
Here is my scenario:
Database DB1 on Server1 is log shipping primary in data center.
Database DB1 on Server2 is log shipping secondary; Server2 is in remote location. Logs are shipped from data ...
2
votes
0answers
61 views
How to safely take an SQL job out of the schedule?
There is a table | jobID | status | startTime | endTime | and a job, that is scheduled to run every X seconds, it will take the first undone job ID, put it in stored proc and run it. Stored proc takes ...
2
votes
0answers
190 views
Why do I get “The initial snapshot for publication is not yet available.”?
We are using Transactional Replications with updatable subscriptions. 1 publisher, 1 subscriber.
SQL Replication started encountering a constraint error on 3/6 at 10AM because people at two different ...
2
votes
0answers
132 views
SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?
I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in.
My small development team needs to have local ...
2
votes
0answers
70 views
How do I get more details on a full text catalog error?
I have an error that is repeatedly generated on a SQL Server 2005 instance running the databases for MS Team Foundation Server.
'Severity 16' occurred on INSTANCENAME
Looking in the SQL Server ...
2
votes
0answers
114 views
How to manage dynamic tables in Visual Studio 2010 Sql Server Database Projects
I am migrating a common set of databases in to a VS 2010 Sql Server Db project so we can keep it in source control, and deploy common changes etc.
The databases are for the most part the same, except ...
2
votes
0answers
70 views
SQL Server 2008 Restore from D2D
In that past year we started using a D2D network device to store our SQL Server backups. This device does dedup and compression. It looks just like any standard CIFS share (\\d2d\sql_backups\...). ...
2
votes
0answers
38 views
Is it possible to have a valid backupset with null position?
In database restore process I need to rely on position column exists in backupset record to restore the latest backupset.
Restore the latest backup on the database
I noticed sometimes position is ...
2
votes
0answers
114 views
SQL71561 Error on Schema compare after initial import from database
I have created a new sql server project with SSDT 2012, then I went to import an existing database and it created all my scripts. After that I did a schema compare between the project and the database ...
2
votes
0answers
47 views
What is correct process to physically move an availability replica to another location
Current situation is we have 3 SQL Servers with one availablity group and we plan on moving one of the secondary replicas out of HQ to another location. There will be the span of a few hours between ...
2
votes
0answers
129 views
Can 2 tables lock each other if concurrent read/update do not affect same rows? pagelocks off
Can 2 tables cause a deadlock, if the pagelocks are off, and the rows are not related.
E.g.
Query 1 runs for a few seconds
Select * from Orders where CustomerID = 1 and DateOrdered between @D1 and ...
2
votes
0answers
71 views
What is the effect of replacing indexes with filtered (non-null value) indexes?
Our project runs a very large, very complicated database. So about a month ago, we noticed that the space used by indexed columns containing null values was getting too large. As a response to that, I ...
2
votes
0answers
193 views
How much disk space needed for 100GB of DBs?
Hard to explain in the title, but I'm planning a migration from SQL Server 2000 databases to SQL Server 2008 R2. The databases are under 100GB total space, but this is only with the Simple recovery ...
2
votes
0answers
317 views
Importing Excel files with SSIS
I'm trying to import an Excel spreadsheet into SQL Server 2012 using SSIS. There is only one sheet in the file. The file is a SalesForce export. I believe the Sheet name changes depending on when the ...
2
votes
0answers
95 views
Local users access SQL Server correctly, but domain users don't return all the data
We have just changed from a workgroup to a domain running SBS 2012 and SQL Server 2008R2. The problem I have is when logged in as a domain user my application connects to the server but only returns ...
2
votes
0answers
110 views
Last Known Successful DBCC CHECKDB
I understand that looking at DBCC PAGE is supposed to show me the last known good DBCC CHECKDB but I am not seeing this work correctly.
I have a database that I know is corrupted. If I run DBCC ...
2
votes
0answers
66 views
Configuring SQL Server Job agent
I am trying to configure the SQL Server Job Agent using the following scripts
USE [msdb]
GO
CREATE USER [mydbuser] FOR LOGIN [mydbuser]
GO
EXEC sp_addrolemember N'db_datareader', N'mydbuser'
GO
EXEC ...
2
votes
0answers
197 views
SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
I wrote a report that is executed by a few hundred users each day and the underlying stored procedure for the data set only takes milliseconds to execute. According to the ...
2
votes
0answers
100 views
SQL Server : Transactional Replication Filter By Computed Column
There is a database that contains records for multiple groups of people. These records do not contain a column indicating which group the record is "owned" by (very frustrating). I need to setup ...
2
votes
0answers
111 views
SQL Server Event Alerts Lack Enough Details
I setup SQL Server Alerts to send me emails whenever certain events (by severity) occur. Below is an example of en email I received for a "014 - Insufficient Permission" severity event of Type "SQL ...
2
votes
0answers
39 views
improving this goal query
Goal
joining the two tables: tbl_quickSearchParam (fulltext search results) against tbl_product ( active products : prod_status = 1, group by prod_image_name)
create table tbl_product (
...
2
votes
0answers
253 views
SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It
I really need help on understanding this deadlock, i've already replaced the values,
mind if anyone helps me interpreting where my deadlocks are coming from?
What does e_waitpipegetrow mean?
btw, i'm ...
2
votes
0answers
179 views
Tables not shown in SQL Server Enterprise Manager
For some reason 3 tables which are clearly in use by the application are not
listed in the Tables view in SQL Server Enterprise Manager. It's SQL Server 2000.
When generating a diagram, a popup ...
2
votes
0answers
178 views
Restore database from multiple .bak files
I have a bunch of .bak files used as a DB dump for SQL server.
Each one of them is part of the backup (media set families?).
I need to import/restore them. Just to emphasize, the need is load the data ...
2
votes
0answers
83 views
How to Audit for Access with Cross Database Ownership Chaining
I've just joined the data team of a new company and we have a large SQL Server environment (100+ instances) and cross database ownership chaining is on by what I gather is a necessity. I'm looking for ...
2
votes
0answers
49 views
How To Diagnose Slow sp_mssetupbelongs
I am using merge replication with SQL 2012.
When performing a clean sync using the merge agent I am getting a timeout on this stored procedure,
sp_mssetupbelongs
I am wondering what the best way to ...
2
votes
0answers
107 views
How compatible are Sybase and SQL Server clients connecting to the alternate back end?
Given the shared history of the Sybase and SQL Server products, and their use of a similar (identical?) wire protocol in TDS, what definite statements can be made, if any, about cross compatibility.
...
2
votes
0answers
101 views
ERWIN create and use database
Im trying to generate physical database from my logical model using ERWIN 7.
All is well in the script that is generated automatically, there is only the problem that the model is created in the ...
2
votes
0answers
45 views
MSMerge_contents Table Populated After One Sync
I am running merge replication with SQL 2012.
When I first create my publication the MSMerge_contents table is populated with a large number of records with the colv1 being set to 0xFF.
When I run ...
2
votes
0answers
80 views
How To Analyse Index Scans
I am using merge replication with SQL Server 2012.
During a sync using a merge agent there are a large number of index scans. I can see this by running a profile capturing SCAN:Started and ...
2
votes
0answers
70 views
Is it normal for tempdb TPS to be higher than all other databases combined?
I'm investigating some performance issues on a production DB here, and I've noticed a slightly odd thing that I'm not sure is weird or not.
If I run a quick Performance Monitor trace for the ...
2
votes
0answers
195 views
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
I have two SQL Server instances in an availability group. They are not mirrored.
I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
2
votes
0answers
80 views
SQL Server fulltext_semantic_languages
When trying to install a semantic search example, I'm running into a problem.
There are some steps in the example to check if the 'new' Semantic Search and Full Text Search are installed.
...
2
votes
0answers
231 views
Finding Microsoft.AnalysisServices.Xmla dll in SQL Server 2008 R2
I'm not able to find Microsoft.AnalysisServices.XMLA.dll that I need to import
using Microsoft.AnalysisServices.Xmla;
I have found some articles and answered questions for SQL Server 2005 and 2012. ...
2
votes
0answers
60 views
How to display differential backup date in SSMS Object Explorer Details
SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display.
Full and Transaction Log ...
2
votes
0answers
34 views
List of changes required to upgrade scripts after starting to use replication in SQL Server
We have recently setup transactional replication on our test and production databases. As part of that change, we've had to make changes to how we create upgrade scripts as well. The goal is to make ...
2
votes
0answers
56 views
Merge Replication Optimization
I am running Merge Replication on Microsoft SQL Server 2012 through web sync.
Is there a way to recognize when regenerating a new snapshot and applying it would be more efficient than running a ...
2
votes
0answers
135 views
How to Rename Table or Field With Merge Replication
I am using merge replication with SQL 2012. I am trying to rename a published table, and rename a published field.
These operations are not permitted in merge replication.
However I can think of an ...
2
votes
0answers
194 views
SQL fulltext accent insensitive
I am using SQL Server fulltext containstable and the column which is indexed has collation Czech_CS_AS, so why when I have word "byt" it returns records with word "být" too. I thought that the ...
2
votes
0answers
110 views
How do I back up and restore a SQL Azure database?
How do I back up and restore a SQL Azure database?
For that matter, how do I back up and restore an entire Azure account? Let's suppose I am working at a company and I buy a 3 month trial account ...
2
votes
0answers
262 views
Linked server issue
I made a linked server between two sql server instances. The remote one I have very little control over. When I try a query I get this:
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for ...
2
votes
0answers
212 views
Grant User Permission To Restore Database And Access that database in sql server?
I want to create a user having dbcreate, db restore server roles and will be db owner of that database. But there is only 1 server roles available that is dbcreator, which can create database is also ...
2
votes
0answers
138 views
How can I manage Primary Key length limit of 900 bytes when using hirarchyid 2 columns?
I have to define a Primary key on a table which has following 4 columns and its data types.
GSiteID hirarchyid,,
SiteID varchar(10),
GComID hirarchyid,
ComID nvarchar(10)
As we know there is limit ...
