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
0answers
131 views
+50
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing
We are using SQL authentication & .net 4.0 Connection strings to connect to an Enterprise Edition 2012 SP1 SQL Server on a windows 2008r2 Enterprise Server. We use about 50 Servers split into 8 ...
7
votes
0answers
85 views
SQL Server Analysis Studio naive Bayes attribute has too many states
I'm using SQL Server Analysis Studio and I'm trying to train a naive Bayes classifier. I've got an attribute called "item description" that basically represents products you can buy at a store. I've ...
6
votes
0answers
58 views
More CPU cores vs faster disks
I'm part of a small company so as usual covering a number of different roles. The latest of which is procuring a dedicated SQL Server box for our .NET web app. We've been quoted on a dual Xeon E5-2620 ...
5
votes
0answers
145 views
DB_ID context from farther up call stack
In SQL Server, is it possible to get the DB_ID from the context from farther up the call stack?
My goal is to create some handy (and admittedly hacky) utility functions in a dev sandbox database ...
5
votes
0answers
254 views
SQL-08S01 error in FreeTDS/Azure when executing stored proc for a few minutes from Linux (but not from Windows)
I get this error on Linux (Ubuntu and CentOS) when executing a stored proc from Perl/DBI/ODBC/FreeTDS to SQL Azure:
[unixODBC][FreeTDS][SQL Server]Read from the server failed (SQL-08S01)
I don't ...
5
votes
0answers
102 views
Msg 14027, Level 11, State 1, Procedure sp_MSrepl_addarticle [table] does not exist in the current database
Before setting up SQL Server snapshot replication, I backed up the database from ServerA and restored it to ServerB. Both servers are running SQL Server 2008 R2 SP1.
In trying to setup snapshot ...
5
votes
0answers
322 views
Service Broker: Queue Monitor is dropped after poison message
I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer.
When I setup event ...
4
votes
0answers
58 views
Clear schema from database without dropping it
I'm working on a school project where I have a SQL Server with a database for my team.
I already imported a local database created with Entity Framework.
Now the model has changed, table properties ...
4
votes
0answers
292 views
Impact of changing the DB compatibility level for a Published replicated DB from 90 to 100
I have a SQL Server 2008 R2 server with a bunch of published databases that are currently operating under compatibility level 90 (2005).
The subscription databases are also SQL Server 2008 R2, ...
4
votes
0answers
156 views
Initializing Transactional Replication From Backup
There is an option when setting up a publication for replication to Allow Initialization From Backup. We have been creating replicated databases for several years now and have always initialized from ...
4
votes
0answers
35 views
How to remove a database server from Utility Explorer
I use the Utility Explorer to monitor some of my databases but I forgot to remove one before retiring the server. Normally, you could just right click and select "Remove Managed Instance" but I can't ...
3
votes
0answers
23 views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
3
votes
0answers
102 views
Where and how to store my weird datamart
I could really use some help here.
Here's my situation.
I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
3
votes
0answers
62 views
When SQL Server uses Multi Page Allocation
In SQL Server 2008 R2
I always wonder what can be consumer of MPA (multi page allocation) in SQL Server? I know data page is always 8K so is there a situation where data/index page make use of MPA? ...
3
votes
0answers
63 views
SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log
Using SQL Server 2012 on Windows 2008 R2
I have been getting errors in SQL Logs for failed login for NT AUTHORITY\SYSTEM.
All of SQL Server's services are running under their own Domain accounts, ...
3
votes
0answers
38 views
Error statement is not logged, only *password-— with many dashes
I use extended events to store database errors, like this:
CREATE EVENT SESSION [ErrorCapture]
ON SERVER
ADD EVENT sqlserver.error_reported
(
ACTION
(
sqlserver.client_hostname,
...
3
votes
0answers
82 views
Preferred Methods Of Indexing MS SQL Server Audit Data To Splunk
What is your preferred method for indexing MS SQL Server for Splunk? I am collecting audit data in various environments by various means (profiler, app logs, and extended events) but I hope to ...
3
votes
0answers
116 views
Is SQL Server data compression categorically good for read-only databases?
Some literature on SQL Server data compression I read state that the write cost increases to about four times what would normally be required. It also seems to imply that this is the primary downside ...
3
votes
0answers
153 views
SSIS Recordset Destination error
I have an SSIS package targeted at SQL Server 2012.
I have it deployed into the Stored Packages in Integration Services and then have a SQL Server Agent job which executes it.
The first part of the ...
3
votes
0answers
111 views
How do I know if my database partitioning is done well?
I have a sneaking suspicion that the guy who wrote the partitioning functions at my place of work did a fairly poor job. For certain queries (maybe 20% of them) we see incredible performance boosts ...
3
votes
0answers
80 views
Key Lookup and Full-text index
I have the following query:
SELECT T2.Title
FROM TitleTable T1
INNER JOIN TitleTable T2 ON T2.FKID1 = T1.FKID1
WHERE T1.FKID2 = @ID_PARAM1
AND T2.FKID2 = @ID_PARAM2
AND ...
3
votes
0answers
34 views
SQL Server 2005 not collecting logins in the log file
I am currently running SQL Server 2005 Standard Edition on a Windows 2003 server machine.
I have gone to the properties of the server and confirmed that the Login Auditing is set to both failed and ...
3
votes
0answers
76 views
What utilities can I use to simulate I/O load for a DB restore and DBCC check?
I'm trying to figure out the peak load I can sustain on new hardware I procured for validating backups and performing DBCC checks. I've been using Crystal Diskmark to get throughput stats which helped ...
3
votes
0answers
93 views
What are the best practices for backing up a secured SQL Server 2012?
I want to state right off the bat that I'm not looking for information on how to backup a SQL Server. I've got that taken care of.
I'm looking for some form of documentation that will tell me the ...
3
votes
0answers
98 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
3
votes
0answers
153 views
Why can't I read my transaction log backup file using fn_dump_dblog?
I'm using this blog on sqlskills.com as a guide to practice finding the relevant LSN in a transaction log backup for point in time recovery.
After backing up the transaction log, I attempt to read it ...
3
votes
0answers
119 views
SqlDependency permissions
The db is SQL Server 2012. All data tables are in the dbo schema. All data access is done via stored procedures in a different schema (user rt). I want to add query notifications for some tables, so I ...
3
votes
0answers
139 views
MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
I am receiving errors when I try to run a distributed query against different SQL Server 2008 R2. At first I thought this might be cause the servers have been set up on a VM using a clone but after I ...
3
votes
0answers
211 views
TempDB Contention with 24 physical tempdb files on 48 core AMD Opteron box
I just received the following notification about an instance of SQL Server 2005. The instance has a core-to-tempdb-file ratio of 2:1 for a total tempdb file count of 24 files. Contention should not ...
3
votes
0answers
131 views
Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
I administrate a reporting database.
We run all the denormalization process on a DB1 daily then we copy all the data to an another database DB2 on the same server which is queried by web applications ...
3
votes
0answers
70 views
Multiple Merge Replications on same SQL Server Database Conflicts
I have 2 separate merge replications on the same database on a server, one named 'POC' with a single subscriber running continuously, and another named 'Clubs' with ~50 subscribers. As of recently, ...
3
votes
0answers
158 views
SQL Server 2008 R2 - Merge Replication - Can the Distribution Database size cause replication problems?
Setup:
We have a SQL Server 2008 R2 instance running on a central server.
The server is a merge-replication publisher.
We have 'N' subsribers running SQL Server 2008 Express. 'N' can grow to any ...
3
votes
0answers
187 views
How to design a database for financial bond prices?
I have following flat file table composed of bond deal names and asociated prices.
Each deal name is identified by its unique CUSIP and ISIN codes and each deal name is classified with a certain ...
3
votes
0answers
201 views
Tracking object use using SQL Auditing
I am looking for a solution to track object usage in my database. Objects such as tables, stored procedures, and functions.
I discovered SQL Auditing and was under the impression that it's exactly ...
3
votes
0answers
530 views
SQL Server Decimal(9, 0) vs INT
One of our customers uses for some columns the datatype DECIMAL(18,0) in his SQL Server 2008R2 database. Because the columns grow quite slowly, he recently proposed to change the datatype to ...
3
votes
0answers
206 views
Why are runtimes different for a table including a primary key versus a table with a clustered unique index added after population
When I create a temporary table with a PK defined from the outset like this I get great performance in subsequent joins on that key:
create table #temp (
field1 int not null
field2 int ...
3
votes
0answers
219 views
tds: unable connect to SQL Server using servername specified in freetds.conf file
I am using freetds to connect to SQL Server from ubuntu.
First, the SQL Server is running at port 1433 currently. I can telnet it. The following command also works. I can query table data using it,
...
3
votes
0answers
232 views
Query to find optimal filegroups for objects
I have been assigned a task to create four file groups (one per volume) locate tables so that they are located in a manner that during an ETL process no filegroup is being read and written to at the ...
3
votes
0answers
536 views
What Problems Does an Eager Spool Indicate
Currently running on SQL Server 2008 R2
I am attempting to increase performance of an UPDATE statement. I notice an Eager Spool operation in the showplan popping up. My understanding of spooling ...
3
votes
0answers
666 views
Which workarounds exists to missing relative path feature of SQLCMD :r?
I'm not the first to notice the lack of this feature.
But I wonder if there are some useful workarounds.
I want to deploy a main script and some depended scripts in the same folder.
BTW Is there a ...
2
votes
0answers
14 views
Debugging SSAS Timeouts
I have a drill-through problem apparently related to security. Users in one role are seeing timeout failures when trying to invoke a drill-through action. They have permission on the action through ...
2
votes
0answers
29 views
Server permissions of an activation stored procedure of a Server Broker queue
I have a stored procedure that queries the sys.dm_exec_requests view. In the stored procedure the view only returns one row, while the stored procedure needs to see all of them. The MSDN article on ...
2
votes
0answers
31 views
Failover only working for Classic ASP, not ASP.net
Setup:
All machines run Windows Server 2008 Enterprise
SQL Server 2012 Standard (Primary)
SQL Server 2012 Standard (Mirror)
SQL Server 2012 Express (Witness)
Root issue: Our ASP.NET application is ...
2
votes
0answers
17 views
ODBC - how to set up ODBC driver for 2 languages (for different code page)
How to set up an ODBC driver to operate the Polish code page (1250) and Lithuania (1257) at the same time? Although the code page Lithuanian is wider than the Polish code page, the driver incorrectly ...
2
votes
0answers
29 views
How to remove leaf member values?
I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy.
When you ...
2
votes
0answers
33 views
Coerce columnstore to operate in batch mode
I want to try the column store index in SQL Server and im trying to get my queries to run in batch mode, i rewrote my query this way( it had an outer join before) but the execution plan still show ...
2
votes
0answers
24 views
Combining full-text-search queries
I have two tables in a SQL Server database with basic fulltext indexes:
CREATE FULLTEXT CATALOG table1_catalog;
CREATE FULLTEXT INDEX ON table1
(
name1
)
KEY INDEX pk_table1
ON ...
2
votes
0answers
38 views
Multithreading caching in SQL CLR
Is there any mechanism available to a SQLCLR assembly for caching that will still work when the assembly is registered as "safe"?
The cache needs to be thread-safe, so it can be shared by multiple ...
2
votes
0answers
93 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
44 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') ...
