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).
7
votes
1answer
320 views
SQL Server 2008 R2 corrupted after changing MAXDOP
My SQL Server 2008 R2 doesn't work after changing the MAXDOP parameter on instances.
I have 6 instances located on the same physical server and I changed MAXDOP from 1 to 2 on 5 instances. After ...
7
votes
1answer
202 views
Hard limitation for merge replication article count?
A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article ...
6
votes
1answer
60 views
Dropping Hypothetical Indexes
In the past I thought I'd deleted hypothetical indexes using either a DROP INDEX statement for clustered indexes and DROP STATISTICS statement for non-clustered indexes.
I have a database that is ...
6
votes
1answer
205 views
problem running xp_cmdshell when Application Name set in connection string
I have an app on 10 or so servers that runs a few xp_cmdshell statements against MSSQL 2008. It works fine on all the servers except for one. To make things worse, I can run all the commands in SQL ...
5
votes
1answer
77 views
Efficiently Filter Large Set With Disjunctions
Let's say I have a single table
CREATE TABLE Ticket (
TicketId int NOT NULL,
InsertDateTime datetime NOT NULL,
SiteId int NOT NULL,
StatusId tinyint NOT NULL,
AssignedId int NULL,
...
4
votes
1answer
74 views
General tool to load dump files
I am a big fan of Postgres both for its price but also for its features.
I am going to have to need to upload into it both Oracle dump and SQL Server files.
I will try to ask and beg for plain .csv ...
4
votes
1answer
85 views
Process attempted to unlock a resource it does not own
SQL Server 2005 SP4 32-Bit
I have a DBCC CHECKDB job running nightly. Last night, soon after the job started, I got the errors below. The database is NOT in suspect mode, and CHECKDB comes back clean ...
4
votes
1answer
174 views
Newly discovered SQL Server Express has all databases inaccessible/offline
We have several remotes sites at my company and today one of the employees came to me and said their SQL reporting tool stopped working. Up until this point I did not even know this server or ...
4
votes
1answer
154 views
SQL Server database design for “archived but available” data
We have this large database (>1TB) that we intend to "shrink". The database revolves around one main entity, let's call it "Visit". For discussion, let's say it is a database for a medical practice.
...
4
votes
1answer
127 views
SSRS appears to be ignoring Permissions set using Report Manager
I have setup SSRS on SQL Server 2008 in native mode.
As an administrator I can login to report manager, upload reports and run them, and also use the Web Service URL to generate reports.
I have also ...
4
votes
1answer
114 views
MI Data Warehouse Advice
I have recently started a new job and part of my remit is to try to rescue the Management Information (MI) Data Warehouse. I use the term Data Warehouse very loosely here!
The server setup is:
...
3
votes
1answer
32 views
SP with Encryption Read/Writes Stats
If a stored procedure in SQL Server 2005 is created with the syntax "WITH ENCRYPTION" ,are the reads and writes of the encrypted stored procedure recorded in the sys.dm_db_index_usage_stats? I am ...
3
votes
1answer
26 views
Fulltext stoplist replication
In MS SQL Server 2008 R2 there is replication of table with fulltext index on it.
But stoplist that is associated with replicated fulltext index doesn't replicate.
Is there any possibility to ...
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:?
...
3
votes
1answer
91 views
Slow SSRS Report in production
I have an SSRS report which gets its data by firing a series of stored procedures.
Now the report is timing out big time when run in production, yet when I pull down the prod database and restore to ...
3
votes
1answer
100 views
Azure SQL Administrator Can't Access Master Database
I created an SQL server and database. I can log in to the database manage page with my administrator account, and manage the database I created, but when I try to look at the master database, it says:
...
3
votes
1answer
39 views
Create Scheme that allows for fluidity between entities
We are a small rapidly evolving company and recently investigated switching databases from SQL Server to a graph database. We like the graph approach because of the fluidity and openness that it ...
3
votes
1answer
132 views
SQL Server 2005 Replication
I am in the process of creating Replication between 2 Remote Servers, server 1 is the Distributor and Publisher and server 2 is the Subscription.
server 1 windows 2003 server 192.168.10.1 connected ...
3
votes
1answer
63 views
Named Pipe Provider Error code 40
I have literally tried everything, from enabling named pipe to adding exception to ports in the firewall, to everything possible in surface configuration. I can connect to the SQL instance(using TCP ...
3
votes
1answer
197 views
sql server database sharding - what to do with common data / non sharded data
We have a very large scale enterprise level database. As part of our business model all web users hit our web servers at the same time each month which in turn hammer our sql box. The traffic is very ...
3
votes
1answer
222 views
SQL Server 2008 Setup Error 0x80070490
I am trying to install SQL Server 2008 x64 on Windows 2008 R2 and keep getting the following error:
SQL Server Setup has encountered the following error: Element not
found. (Exception from ...
3
votes
1answer
214 views
query processor ran out of internal resources and could not produce a query plan
This is showing up in the logs several times a night. How do I find the query causing the issue? SQL Server 2008 R2 Sp1.
Thank you
3
votes
1answer
170 views
Applying user-defined fields to arbitrary entities
Currently we have an old (rather crude) system that has user-defined fields, which are mapped against rows in arbitrary tables. This was an after-the-fact modification based on a customer request, and ...
2
votes
1answer
46 views
Is this a good strategy for importing a large amount of data and decomposing as an ETL?
I have a set of five tables (a highly decomposed schema for an ETL if I understand the nomenclature) that I'm going to load via bulk import, then run some inserts from those five tables into a SLEW of ...
2
votes
1answer
61 views
Service Broker stops working
I'm new to Service Broker. Our existing Service Broker suddenly stops working and I can't figure out why.
When I try to enable Service Broker (which is already enabled) I get this in SQL error log:
...
2
votes
1answer
37 views
SQL Server database schema (and likely, some data changes) - how to auto-distribute over many database instances
Our development involves a SQL Server database (also might be Oracle or Postgres later) and we would sometimes make database schema changes or some other interventions in database.
What solutions ...
2
votes
1answer
49 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses, and after posting on superuser, was directed over here.
On SQL Server 2005, we currently log certain table changes via triggers using ...
0
votes
0answers
312 views
Using SSIS to download an attachment from Exchange/Outlook
I am recieving a weekly email that includes an attachment of an excel file. I'd rather not how to manually drop this email in a file location or manually update the data. I'd like to use SSIS to ...
0
votes
0answers
46 views
Error message installing SQL Server 2005 Enterprise on my Windows 7 Enterprise
I have a problem installing SQL Server 2005 on my Windows 7 Enterprise 32 bit operating system.
The installation never completes. The error log file states I need to have IIS installed (I do and it ...
0
votes
0answers
121 views
“PRIMARY filegroup is full” error after reaching 10G
Could not allocate space for object 'dbo.test_mailattspeed'.'PK__test_mai__3213E83F46BD6CDA' in database 'XXXXXXX' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded ...
0
votes
0answers
134 views
Consequences of multiple FK's from same column to multiple tables
I know it's possible to create multiple FK's to different tables using the same column, other than the performance hit caused by having a FK, are there any negative consequences of doing so?
...
0
votes
0answers
129 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS database instance using the master account I created when creating the ...
0
votes
0answers
201 views
SSIS package to create maintenance plan fails silently
Here's what I did:
Connect to SSIS on server A (from management studio on server B, click connect, choose integration services, choose server A)
Find required maintenance plan
Right click and export ...
0
votes
0answers
45 views
How to properly design this type of relationship
I am building a model with the following requirements:
Items may have attributes
Attributes may be of type: 'Choice', 'FreeText', 'Number'
I am not quite sure how to relate the item to attribute ...
0
votes
0answers
107 views
C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\DATA
I am trying to query SharePoint list data from a database named like STS_bangbus_1 database, but there seem to be only one SQL Server instance with the named “bangbus” aka “SHAREPOINT”, with ...
0
votes
0answers
196 views
with using PIVOT table sql server
I am facing a small issue while using PIVOT table.
My problem is as following.
I have a single table with the procedures id and their steps and i want all the steps needs to be displayed in 5 column ...
0
votes
0answers
37 views
Merge Replication Finding Session Id
I am using merge replication with SQL 2012.
I am writing a custom business logic handler, and would like to know if there is a way to get a session id?
For instance if the custom business logic ...
0
votes
0answers
175 views
Cannot change the Delete Rule of a self referencing foreign-key-relationship to cascade delete
I have the following table
[dbo].[myObj](
[ID] [int] IDENTITY(1,1) NOT NULL,
[fk_ParentID] [int] NULL
)
and I have a relationship from fk_ParentID to ID.
I want to change the Delete Rule in ...
0
votes
0answers
258 views
Having trouble creating a unique key for full-text index on an indexed view in SQL Server 2008r2 and I am not sure if the string length is the cause
I am having trouble creating a unique key for a full-text index on an indexed view. My definition is as follows:
CREATE VIEW [dbo].[vw_inventory_metadata] WITH SCHEMABINDING AS
SELECT ...
0
votes
0answers
77 views
How to user the Tablediff Utility with Replication Filters
I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence.
I see a problem with this approach though. This is because I am using parameterised filters to ...
0
votes
0answers
134 views
Redis data structure for networking site
I am developing a social networking website, and in this website I am giving friend suggesstion, friend list, mutual friends list (between logged in user and another user). I am doing all this very ...
0
votes
0answers
174 views
How To Speed up Merge Replication
I am running SQL2012 merge replication on a netbook using SQL Express as a subscriber. The netbook has 1GB of RAM.
The replication process works quite well, but it is when it comes to applying the ...
0
votes
0answers
61 views
Can a Merge Filter Have Multiple Parent Tables?
I am using merge replication in SQL 2012. I have a situation where I am using join filters to filter out what records are being replicated to the subscriber.
When I look at the stored procedure,
...
0
votes
0answers
78 views
How to Fix Merge Replication Error
I am using merge replication with SQL server 2012. I have set up a subscription and publication and everything was working.
I now get this error message,
Cannot have a dynamic snapshot job with both ...
0
votes
0answers
114 views
In SSB, how would you implement external activation to a particular (1) user when you only have one initiator queue and one target queue?
On a database which has multiple user application instances en-queuing messages to one initiator queue sending messages to a target queue which activates a server application, I am revising the ...
0
votes
0answers
38 views
Subscribing to Subsets of Data in Merge Replication
I am replacing a custom sychronisation system with merge replication.
The current system on the server side allows you to select what data a client can sync to their device and edit, i.e. they will ...
0
votes
0answers
98 views
Changing INSERT IDENTITY from OFF to ON in live DB for several tables
I have several tables setup with IDENTITY INSERT OFF and I need to change this to IDENTITY INSERT ON. A lot of these tables have 500,000+ records. These tables are basically mirrors of other tables ...
0
votes
0answers
401 views
Sys.WebForms.PageRequestManager Error in SSRS
When i am executing on SSRS report i am getting below error
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code ...
0
votes
0answers
549 views
Could not open File Control Bank (FCB) for invalid file ID X when restoring from snapshot
We have a scenario in which we, during integration tests, make a backup of an existing database and restore it under a new name. We then create a snapshot of our "new" database. After each test we ...
-1
votes
0answers
43 views
Unexpected index scan against partitioned table
I have a set of partitioned tables with CIX on (ID, DATE) and partitioned on DATE.
There is another identical set of non-partitioned tables with CIX on ID.
Case A: T1 and T2 are non-partitioned ...
