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).
0
votes
0answers
8 views
XML data source with XSD validation importing the same data despite different files
Please bear with me, I've never used XML as a data source, nor am I familiar with XML itself, so I'm not entirely familiar with the nomenclature.
I have a series of XML files with data to be imported ...
0
votes
0answers
7 views
How to do an in-place upgrade of SQL Server 2005 Express to SQL Server 2008 R2 Express
I would like to upgrade my SQL Server 2005 Express instance which is installed using this command:
SQLEXPR.EXE/qs /action=INSTALL /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine /INSTANCENAME=ABCD ...
0
votes
0answers
77 views
how to find similar word with more similarities
how to Find words with length less than or equal...
declare @inp nvarchar(max),@data nvarchar(max)
set @inp='You can dance, you can jive, having .... jove... jve, ...'
set @data = 'jeve'
...
0
votes
0answers
31 views
SSMS 2012 error message: evaluation period expired despite Edition Upgrade
Problem similar to this one only with SQL Server 2012. None of the suggested registry edits have worked. This problem was supposed to have been fixed back in 2008 SP1.
Here's the sequence of ...
0
votes
0answers
42 views
Hierarchical data best practices
I'm looking for a best practicies\databases to solve our problem:
Currently we are using SQL Server 2008 R2 with HierarchyId. It works ok, but we have a lot of performance penalties due to this ...
0
votes
0answers
76 views
DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS'
I have inherited a few scripts that are pumped through a c#.NET custom app to update a SQL2005 SP3 database. One of these scripts does a deletion on a user table called msw_timer_task, based on a ...
0
votes
0answers
56 views
Table Constraint causing deadlock
I have a table. When two transactions are inserting a large no of rows into table grid I am getting a deadlock due to INSERT/SELECT. So INSERT query has X lock on clustered index but since i am doing ...
0
votes
0answers
25 views
Displaying Hexadecimal Characters in Reporting Services Report
How do I properly display hexadecimal characters in an SSRS report?
These characters: http://www.htmlhelp.com/reference/html40/entities/special.html
E.g., “ should display as left double ...
0
votes
0answers
33 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
0
votes
0answers
97 views
How to create table set from several XSD in SQL Server 2012 or with VS 2012
Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#?
Problem is I cannot use:
USE Database_test
GO
CREATE XML SCHEMA COLLECTION Collection_from_XSD AS
N'
...
0
votes
0answers
27 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
0
votes
0answers
31 views
How to bind contract to service?
I have a service broker setup where server A is updating server C with no problem. I now need to add another service broker setup where server B also updates the same database on server C.
When I ...
0
votes
0answers
14 views
Monitor For Disabled Queue On RDS SQL Server
I would like to somehow get notification of a queue being disabled due to poisoned messages. (The issue is occasional resource contention. Until we solve it, monitoring would help us be aware.) In my ...
0
votes
0answers
52 views
Converting data from MSSQL Server to MySQL using MySQL Workbench and preserving special characters
I am trying to convert a MSSQL Server database with collation SQL_Latin1_General_CP1_CI_AS into a MySQL database using MySQL Workbench. I can successfully complete the process without any issues being ...
0
votes
0answers
49 views
SSIS Data Flow Task Slows Down
I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it ...
0
votes
0answers
25 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
0
votes
0answers
38 views
sql server 2008 error in working
I have Windows 7 professional and SQL Server 2008 Standard
In management studio when press connect it shows this error
( A network-related or instance-specific error occurred while
...
0
votes
0answers
71 views
best way to copy data from MSSQL db to MYSQL DB(remote)
I currently copy data between my local SQL Server to a remote MySQL database linking in SQL and doing a data transformation task but now I'm sending lots of data it is getting very slow.
Just after ...
0
votes
0answers
43 views
Linked server performace issue?
I have created a linked server in sql server 2008 R2 Enterprise Edition for mysql i.e. MySQL database is accessible under sql server environment. I have a created a trigger in sql server such that ...
0
votes
0answers
68 views
SSRS email subscription fails intermittently with “The e-mail address of one or more recipients is not valid”
I have an SSRS server sending mail via smtp to a list of users.
These are all internal users with email addresses of the form user.name@example.com
An email subscription run at 18:05 used to work, ...
0
votes
0answers
52 views
Insert performance deterioration over network
i have a strange issue with a windows application (in delphi) running on a win7 client.
The application has a loops and inserts rows on a SQL Server table.
It's simply an insert statement, repeated on ...
0
votes
0answers
57 views
SQL Server Internal Memory Pressure
I am trying to identify the cause of internal memory pressure. From what I have learned, Resource Monitor Ring Buffer returns an indicator for internal pressure. For example by using this query,
...
0
votes
0answers
34 views
Huge sizes Replication Tables in Sql Server db, how to deal with?
I've a sql server database that is configured to work with old software, i've no details about the software, but i know that DB uses replication.
the DB size dramatically increases.
When i ...
0
votes
0answers
43 views
Invalid Object SQL Server 2005 Express
I have 2 SQL Servers, let's call them A and B. I have a ColdFusion app that runs on server A. It connects to my database, MyDb. I needed to update the db content so I backed up the same db on server B ...
0
votes
0answers
53 views
Cannot start SQL Server service on SQL Server cluster
I have a SQL Server 2008 cluster with 2 nodes. I rebooted both machines and now I CANNOT start the SQL Server service from:
Node1 or
Node2 or
ClusterSQL (the cluster SQL Server)
I am getting an ...
0
votes
0answers
28 views
Merge Replication is Slow for Uploads
I have implemented merge replication with pull subscriptions in production environment. Initially it was working fine, but now a days, its too slow to upload any changes to publisher , but subscribers ...
0
votes
0answers
45 views
Deadlocks in Small Table
Our application is seeing deadlocks while inserting records into a table shortly after installation, while the table is small. These deadlocks eventually go away as the table fills up.
The ...
0
votes
0answers
44 views
RESTORE DATABASE is terminating abnormally
I want to restore the database
My current query is
Use master
DECLARE @ErrorMessage NVARCHAR(4000)
ALTER DATABASE [dummydata] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
BEGIN TRY
...
0
votes
0answers
23 views
Ghost replication jobs in replication monitor
Has anyone ever seen and know the cause of this issue? We have transactional replication with pull subscriptions. At 2am this morning it appeared that the job (that runs every 15 minutes) stalled out. ...
0
votes
0answers
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
0answers
69 views
How to represent class table inheritance (current DBMS-specific way please)?
I want to implement class either-or table inheritance (Account, CatAccountDetails, DogAccountDetails) in SQL Server.
I found a recommendation for MySQL here (How do I map an IS-A relationship into a ...
0
votes
0answers
31 views
Full-text search index size
Is there any analysis about this topic? For example what is the estimated index file size of 1 GB .txt files?
0
votes
0answers
57 views
Are there any good open source tools for DB objects end user manipulation?
I've been recently tasked to provide some object adjustment features for our end users, simple thing like changing the value of two or three fields in some specific business know tables without the ...
0
votes
0answers
84 views
SQL Server link to linked server
My client has a Visual FoxPro database that needs to co-mingle with SQL Server data (SELECT only, no updates or deletes).
After quite a bit of searching I found the VFP OLEDB provider doesn't work ...
0
votes
0answers
66 views
What are my options for building a SQL Server lab in cloud?
There is an excellent post by Jonathan on SQLSkills detailing setup of a completely free SQL Server playground locally using VirtualBox and Windows/SQL Server evaluation editions. I am planning on ...
0
votes
0answers
41 views
Risk of xp_cmdshell
What are the risks associated with enabling xp_cmdshell?
Is it true if a person can execute xp_cmdshell, then he can perform any task on that machine regardless of administrator privilege? Can a sys ...
0
votes
0answers
107 views
FOR UPDATEor INSTEAD OF UPDATE Trigger?
I am working on my project at university - database in MS SQL Server for some sort of travel agency.
I would like to create a trigger to check if I can add another reservation for specific Holiday ...
0
votes
0answers
80 views
SQL Server connection failed for domain user from Mac OS machine
I have SQL Server 2008 R2 SP1. I am using connection string to connect to SQL Server.
In connection string I am passing the driver path, server name, TCP port number, user name with which I want to ...
0
votes
0answers
284 views
SQL Server 2012 SSIS\SharePoint Kerberos auth
I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =)
GOAL:
Use Kerberos to avoid double-hop issue.
USAGE:
User logs onto ...
0
votes
0answers
28 views
tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER
i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
0
votes
0answers
57 views
Migrate PostGIS geometry data to SQL Server spatial data
I am trying to migrate PostGIS geometry to SQL Server Spatial data. Which ETL I have to use?
It's the first time I'll work with SQL Server spatial features.
Thanks for any help
0
votes
0answers
59 views
How to model Week Commencing / Week Ending scenario
I’m reasonably new to data warehousing and I’m struggling to get a feature of my time dimension working. I’d like to model a Week Commencing and Week Ending type of scenario.
I’ve created a DimTime ...
0
votes
0answers
45 views
RedGate Data Compare without reregistering tables
I am using the RedGate Data Compare tool and set up all my tables with the settings I want to use. This took about 4 hours. I want to be able to use these settings for different DBs but when I select ...
0
votes
0answers
527 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 ...
0
votes
0answers
46 views
bad to assign specific processors to SQL Server 2008 R2 cluster instances?
I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
0
votes
0answers
310 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
133 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 ...
