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
608 views
How to structure Master/Detail tables for performance without denormalizing?
Some Background Info
We have a set of tables that holds all the transactions for our system, TransactionHeaders and TransactionDetails. There are roughly 80k Transactions a day which translates to ...
2
votes
0answers
92 views
CREATE ASSEMBLY - EXCEPTION_ACCESS_VIOLATION
I am trying to create an assembly on my SQL Server 2005 server. Here is what I am using:
CREATE ASSEMBLY [SQLCLRTest]
AUTHORIZATION [dbo]
FROM 'path\to\my\file.dll'
WITH PERMISSION_SET = ...
2
votes
0answers
118 views
Allow users to do anything within his own schema but cannot create or drop the schema itself
I have created a schema in SQL Azure using following permissions on my database role:
CREATE ROLE myrole AUTHORIZATION dbo;
EXEC sp_addrolemember 'myrole', 'myuser';
CREATE SCHEMA myschema ...
2
votes
0answers
73 views
Are there any best practices before moving SQL Server to another node (controlled failover)?
Let's say there are multiple jobs running on the SQL Server - we have index maintenance jobs, backups, replication, etc. We would like to perform a switchover using Failover Cluster Manager. Are there ...
2
votes
0answers
182 views
I/O is frozen on database databasename
On SQL Server 2005 log report, everyday I receive the following message:
I/O is frozen on database databasename.
Is it serious ?
How to resolve it ?
2
votes
0answers
229 views
What does duration measurement in sql server actually measure?
What precisely does the query duration measure when conducting a profiler trace?
I have a stored procedure which performs data access (SELECT), and it is taking an average of around 30 seconds to ...
2
votes
0answers
145 views
Could not allocate space for object 'dbo.History' in database '[path to mdf]' because the 'PRIMARY' filegroup is full
I have a local project i am working on, on my own workstation. I use a local SQL server as well.
The project contains alot of data, and as of now, i just need to be able to store all this data in the ...
2
votes
0answers
135 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
2
votes
0answers
271 views
SQL Server : where with cast(value as varbinary) vs cast(value as varbinary(300))
Are there any theoretical performance differences between these queries in the scenarios below.
Scenarios are:
MyTable has Value nvarchar(300)
MyTable has Value nvarchar(max)
Q1:
declare @p ...
2
votes
0answers
144 views
How to do automated archiving for a SQL Server database based on interpretation of database metadata?
I am looking for a solution giving me automated archiving of SQL Server databases based on a smart interpretation of table relationships that is able to archive records from related tables minimizing ...
2
votes
0answers
201 views
SQL Server 2008 replication scenario
First of all sorry about my english, and most importantly, my database ignorance, I'll do my best ;)
Until now, the scenario that I have is as follows:
In a server under our LAN, we have a database ...
2
votes
0answers
69 views
In KB2658214, how does SQL Server know that “correlated AND predicates” are actually correlated?
While diagnosing SQL Server 2008 R2 queries with poor cardinality estimation (despite simple indexing, up-to-date statistics, etc.) and hence poor query plans, I found a perhaps-related KB article:
...
2
votes
0answers
6k views
SQL Server named instance - can connect remotely, but not locally
I have an instance of SQL Server on my machine.
Machine: Bert01
SQL Server instance: Bert2008
I connect to it using SSMS putting Bert01\Bert2008 in the Server name box, using sa and the .
When I ...
2
votes
0answers
158 views
How to get SQLCMD to output errors and warnings only?
How can you get SQLCMD, when executing a SQL script file, to just output any errors or warnings it encounters?
I essentially dont want information based messages to be output.
2
votes
0answers
101 views
MDX Block Calculation Optimisation
I have a query I'm trying to optimise. I have read an article here http://web.archive.org/web/20100823233821/http://www.biblogs.com/2008/03/30/optimizing-countfilter-expressions-in-mdx/ about ...
2
votes
0answers
87 views
Lock timeout on user tables traced back to system processes
I have a problem where users are reporting intermittent errors in an application that is using a SQL Server 2005 database. Nothing jumped out at me at first glance so I took a look at ...
2
votes
0answers
158 views
going from heirarchical XML to heirarchical SQL tables then SQL to c# objects to go to user view, how should I store the data in the databases?
Hi I'm getting my data from a web service using their getData call and it comes in as fairly chunky heirarchical XML, first everything all at once, like
<allData>
<product1>
...
2
votes
0answers
570 views
823 errors on tempdb
Have a couple Fiber channel SAN-attached cluster servers which have been intermittently reporting errors like:
2012-05-09 16:31:54.13 spid74 Error: 823, Severity: 24, State: 2.
2012-05-09 ...
2
votes
0answers
262 views
Logic to convert a UTC date-time to a specific time zone
I have a table which has 1 row per event. Each event has a datetime stamp column which has values in UTC time. Each row has an associated local timezone in which the event occurred.
I have a DIM ...
2
votes
0answers
72 views
ProcessID Owner with third party app
I am having problems trying to audit a third party app with a SQLServer backend.
The app manages users and user access via a SQL table, using a single SQL login to access the databases.
I am trying ...
2
votes
0answers
196 views
SQL Server retrieval error under heavy load (200 concurrent users)
Currently I'm facing an issue in a SQL Server retrieval procedure.
Stored procedure returns unexpected result when executed by many user (No. of users > 40) concurrently for the same parameter. For ...
1
vote
0answers
36 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 ...
1
vote
0answers
38 views
Concurrent Access causing deadlock on the same table
Transaction 1 : SELECT distinct column_id from grid where row_id = @P0
Transaction 2 : INSERT INTO grid (grid_id, row_id, column_id)
In this table grid grid_id is primary key clustered.
...
1
vote
0answers
24 views
Startup procedure for SQL Server availability replica becoming becoming primary
Is there any way how to create a startup T-SQL script/procedure for starting availability replica (when state has changed from secondary to primary)?
I want to disable SSIS jobs specific for related ...
1
vote
0answers
29 views
Is there an effective way to create extended event data that includes stacktraces in SQL Server on a local db instance?
I read Paul Randal's article on getting the symbols for SQL Server. I have a theory that I could get the extended events to read the symbols from the symbol server catch directory by setting the ...
1
vote
0answers
49 views
Asynchronous processing of SQL CLR results that can dynamically add more work
I have an application that consists of Web-services that make calls to a sharded SQL Server database. Each database node has a SQL CLR stored procedures, which given some number of records to process, ...
1
vote
0answers
56 views
Denying direct remote access to SQL Server
I am trying to stop our valid database users accessing our SQL Server remotely via applications other than our system application (e.g., MS Excel). These accesses need to be prevented because they ...
1
vote
0answers
30 views
Registering a SSDT database project as a data tier application fails
I am having problems publishing a SSDT database project and registering it as a data tier application. Let me explain.
I have a database (A) which references two other databases (B & C) through ...
1
vote
0answers
33 views
Slow Response: Initially it's slow and on subsequent restart of the host it works normally
We have SQL Server 2008 R2 32 bit installed on the following hardware:
CPU: Intel Xeon E5310 @ 1.60 GHz
RAM: 4 GB
HDD: Raid
Server: HP Proliant 120
OS: Microsoft Windows Server 2003 R2, Standard ...
1
vote
0answers
21 views
DPM and AlwaysOn - Can they work
How does AlwaysOn tie into DPM for SQL Server 2012? Can we use one or the other for High Availability ? Can they work together or must they be used separately. Thanks
1
vote
0answers
41 views
how can Audit All Login To SQL Server BY ODBC Connection
I MAke Report By Access Form On SQL database
I make ODBC Connection For login To Update the data From Database
Now I want Audit All logins To know who make Update today Or who make Update Now ?
...
1
vote
0answers
94 views
SQL pre-login handshake connection failure
I'm having an intermittent problem with one of my old SQL 2000 servers. Every once in a while it stops accepting logins. I fix the problem by bouncing sqlservr.exe and then it starts working properly ...
1
vote
0answers
106 views
SSIS Merge Join Trouble: 3 tables into 1
So I am having trouble merging three tables into one. All sources are DB, and I am using the MERGE JOIN function. When I join my first two tables, using standard left inner join, it returns the exact ...
1
vote
0answers
20 views
Transfer data from DynamoDB to SQL server 2008?
I want to transfer data from amazon dynamo DB to SQL server 2008. What are the tools or methods which can be used to do this ?
1
vote
0answers
48 views
SQL server slow on Xeon machine, fast on Corei7 x990
i have searched this problem but have had no luck find any improvement.
I have a complex application that used stored procedures in SQL server.
Some of the stored procedures use cursors due to the ...
1
vote
0answers
38 views
Database Timeout Error from VB Application
Recently we are receiving so many database timeout error from different servers
we are using vb application -- which will use ODBC connection to connect database - here no problem
when we run the ...
1
vote
0answers
61 views
Getting LCK_M_S On read committed Snapshot Isolation
I'm getting LCK_M_S on read_committed_snapshot isolation. From my understanding, this isn't supposed to happen since my selects are not placing shared locks anymore.
From my logs, I can see that my ...
1
vote
0answers
61 views
connect sql server using windows authentication in another pc
I am having sql server 2008 r2 express installed in a PC. I have some other PC which are connected to this pc in a local network.Now those PC connect to my pc's sql server using sql authentication. ...
1
vote
0answers
112 views
sql server full text search - fuzzy searching?
Is there a way to configure fuzzy searches in sql server full text search. Meaning if I search for a term called POWDER, I must get matches (i.e. strings) which contain any variations of it within an ...
1
vote
0answers
105 views
Why Am I Getting Deadlock - Please Read Trace
can anyone help me?
i'm getting deadlock on this trace, i'm using symmetricds and i can't understand why i'm getting a deadlock on a certain table.
I'm using sql server 2008 r2, ...
1
vote
0answers
130 views
SSRS Timeline Chart for each day / minute
I'm asked to make a Timeline Bar Chart with SSRS 2012.
There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours).
The bar should have 2 different ...
1
vote
0answers
59 views
sp_testlinkedserver taking long time to time-out
I'm using the following code to check if a linked server is available before running queries on it:
declare @srvr nvarchar(128), @retval int;
set @srvr = 'my_linked_srvr';
begin try
exec @retval ...
1
vote
0answers
84 views
Collect CPU, reads and writes when replaying SQL Profiler Trace
I'm trying to replay a trace on a test environment with SQL Profiler in order to benchmark a database prior to making some performance tweaks. I intend to replay the same trace at various stages to ...
1
vote
0answers
86 views
Troubleshooting Database Mail issues and Service Account permissions in SQL Server
I am having difficulties troubleshooting a Database Mail issue. When I try to stop and start the service using sysmail_start_sp and sysmail_stop_sp, I see a critical error in the Administrative Logs ...
1
vote
0answers
38 views
INSERT BULK in SQL Profiler without values
I started SQL Profiler to catch actions that are doing on server, and among them I found one row where is stated:
SQL BatchStarting: insert bulk table_name <column_list>
but there is no ...
1
vote
0answers
37 views
Will Startup Procs Run Again After Database Recovery?
We have a number of stored procedures that run on startup via the sp_procoption startup:
exec sp_procoption 'ProcName', 'startup, 'true'
A customer's server started up with a very large database in ...
1
vote
0answers
44 views
Migration advice from SQL server 2000 bak
A small and old Windows 2003 server, just crashed; from the backup only the .bak files are available.
A new server will be built, however, as the database is very small (20MB) and the Windows server ...
1
vote
0answers
161 views
Efficiently retrieve big amount of data based on date range
Table EVENTS
TimeStamp |O.Name |Location |Source |
2008-11-12 |Pretorian|Európe |England |
2009-12-24 |Lex Rosa |Európe |Italy |
2010-01-01 |Nasdaq |USA |Whasington |
...
1
vote
0answers
361 views
The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline
SQL Server service restarted/stopped, which cause the production database down n find this errors in System log.
ERROR5:The Cluster service failed to bring clustered service or
application 'SQL ...
1
vote
0answers
78 views
SSMS produces error if query returns too many rows
We are having an issue with a server that we linked to our sql server 2012 instance.
The server that we linked through an odbc or oledb connection is Pervasive SQL.
Selecting from the linked server ...
