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).
1
vote
1answer
65 views
Autogrow of database1_log file in database database1 took 1010871 milliseconds
in past i had a problem of that query been executed for 7 days. i couldnt find any solution. so i created again new database with indexes.
Now i am running a simple query:
UPDATE query
query has ...
0
votes
1answer
42 views
Copy a SQL Server database from one server to another on demand
I have two servers, Prod and Test, both running SQL Server 2008 RTM.
Is it possible to have a PowerShell- or VBScript that could copy a database from one server to another?
The copy should of course ...
3
votes
1answer
33 views
How long takes populating catalog in SQL Server 2008 R2 when update a row?
I have installed SQL Server 2008 R2 with FullText search feature installed.
I created a catalog and fulltext index on a table (let's say Table1). I used the following commands (sql queries):
USE ...
1
vote
1answer
28 views
Sql Server 2012 and native client 10
What is the difference between SQL Server Native client versions 10 and 11? Can I use Native Client 10 with SQL Server 2012 running?
-2
votes
1answer
37 views
Create a Leveling of Intermediaries [closed]
I have a table called Intermediary, which have some columns like
CREATE TABLE Intermediary
(
IntermediaryPK INT ,
IntermediaryID NVARCHAR(20),
IntermediaryName NVARCHAR(200),
IntermediaryTypeID ...
4
votes
0answers
51 views
How to setup SQL active/active cluster to achieve Blue / Green instance switching?
I am wondering if anyone has ever used a multi-instance cluster (nee 'Active/Active') to achieve blue/green (or A/B) deployment scenarios, and what the best way of configuring it is (using SQL 2012 / ...
2
votes
0answers
39 views
Linked Server Login Timeout but SqlCmd works
I've got a SQL 2005 SP4 server that connects to a 2008 SP3 instance via linked servers using the SQL Server server type. Every once in a while, one of those linked servers will start throwing login ...
3
votes
2answers
69 views
Autogrow. Primary vs additional data files
My databases all use autogrow, which grows the primary MDF file on a percentage. But one of the databases, from a third party application grows by adding additional .NDF files.
Where is this option ...
4
votes
4answers
106 views
PK as ROWGUIDCOL or use a separate rowguid column?
There's a long-winded debate going on here so I'd like to hear other opinions.
I have many tables with uniqueidentifier clustered PK. Whether this is a good idea is out of scope here (and it's not ...
1
vote
1answer
55 views
How can I achieve a unique constraint with two fields? [duplicate]
I have a table with e.g. Name and IsDeleted fields. I want to add a row constraint so that only one Name value can have IsDeleted as 'false'. There can be many duplicate Name values, but they must all ...
3
votes
1answer
31 views
Verify Query Request Received
I have a software system which queries data via OLEDB from an external SQL Server 2005. The query request is sent every 15 minutes. I want to verify that the SQL Server is receiving the query ...
4
votes
2answers
53 views
Partitioned Views - Storage of Indexes
I have a single table that contains 4 billions rows that I plan on splitting up in to separate tables for each Quarter of the year. Then I want to create a partitioned view across all tables.
At the ...
0
votes
1answer
47 views
SSIS Adding column to excel sheet template destination when importing from SQL Table Source
I have an excel sheet template that has 3 columns. I also have a SQL server table that has the same 3 columns plus an additional 4th column. I need to import all 4 columns from the SQL table into the ...
2
votes
2answers
35 views
Cannot open SQL Server profiler file
Scenario
Debugging a failed transaction, I asked the DBA to run a trace on SQL Server. Eventually he send me a .trc file.
Issue
I use the fn_tracegettable() function to access the trace:
select * ...
2
votes
1answer
46 views
SQL Server full safety mirror commit overhead less then Time to send?
How is it possible that the time to send value is greater then the mirror commit overhead? The mirror operates under full safety so this means that the commit is only done @ principal when the commit ...
5
votes
1answer
348 views
How to set SQL Server index pages per fragment?
I have SQL Server 2008, and a number of databases. I have discovered that one of my table's indexes is extremely fragmented (How I know: http://msdn.microsoft.com/en-us/library/ms189858.aspx)
The ...
4
votes
1answer
37 views
Performance impact of sp_configure blocked process threshold change
I've been tasked with identifying any blocking happening on a production server. My plan to achieve this is to use
EXECUTE sp_configure 'blocked process threshold', 5
In combination with a server ...
-4
votes
0answers
36 views
Why only some data don't upload to the SQL database? [closed]
When I upload data from a text file to a SQL database, only some data did not save in database, other data saved (same text file) eg. I upload Sales of April of the 20 distributors by using 20 text ...
0
votes
1answer
26 views
When creating remote BLOB store is “RBSFilestreamFile” always the name of the file to be added to the FILEGROUP?
When creating a remote BLOB store in SQL Server (2008 R2) is "RBSFilestreamFile" always the name of the file when adding it to the FILEGROUP like in this query (this is the name I've seen used in ...
0
votes
0answers
17 views
Is it possible to have multiple RBS BLOB stores used by a single database (SharePoint 2010)?
I am working on backup/restore software for SharePoint 2010/13 and need to know if it is possible for a user to configure multiple BLOB stores for a single content database.
i.e. In the steps to ...
4
votes
1answer
43 views
Execute output from query
I've got this query that builds my drop login statements. As part two I want to execute this output. Ideally I want to do this in a sql job with two steps (generate and execute). Can this be done?
...
0
votes
2answers
35 views
SQL Server 2005 xp_sendmail error
I have come across a SQL 2005 server that uses SQL mail to send emails. This setup works fine as long as the MAPI profile points to an Exchange 2003 server, but breaks when the profile points to an ...
2
votes
3answers
119 views
Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?
Does the SQL Server CASE statement evaluate all the WHEN conditions or does it exit once it finds a WHEN that evaluates to true? If it does go thru the entire set of conditions does that mean that the ...
0
votes
1answer
74 views
Error installing SQL Server 2008 - all componets installed successfully except database engine
Below is the error I copied, please someone help me, I have tried at least 10 times in the last 3 days. It is SQL Server 2008 R2 and I wanted to install it on Windows 7.
Microsoft SQL Server 2008 ...
0
votes
1answer
64 views
Efficient way to fetch records since a given criteria
I'm trying to implement a logic where the user can say give me n records since a given id#. E.g.
SELECT TOP (100) col1, col2, ... colN
FROM Table1
WHERE ID > @id
ORDER BY ID
Performance is the ...
8
votes
2answers
168 views
What throughput should I expect with MPIO?
Dell PowerEdge 2950 with two 1 Gbps NIC's going to two 1 Gbps ports on a switch which then goes to a NetApp with four 1 Gbps NIC's that present as one virtual interface. 24 drives, 7200k SATA, NetApp ...
1
vote
1answer
48 views
SQL Server 2008r2 Enterprise evaluation expired - Options?
I have a client that has a recently expired SQL Server 2008r2 Enterprise Evaluation edition. I've been tasked to get it licensed and running SQL Server 2008 r2 Standard. How can I achieve this?
0
votes
0answers
20 views
Aggregate query on multiple values of same field [migrated]
I am using sql server 2012, I have a table of credit card transactions as follows:
CardScheme RespCode
=========================
Visa Declined
MasterCard Approved
MasterCard Approved
...
6
votes
2answers
70 views
Turning OFF CHECK_POLICY by default
We moved from SQL Server 2000 to SQL Server 2005. The client software, which I can not change, creates a user without option
CHECK_POLICY = OFF;
After creating a user, I have to run the command
...
0
votes
1answer
37 views
Oracle database link via ODBC to SQL Server does not recover automatically
I have a test environment with an Oracle 10XE database which is linked to an SQL-Server 2005 via an ODBC data source. For reference here I named the connection MSSQL_LINK. The production environment ...
0
votes
1answer
28 views
The UPDATE permission was denied on the object
I'm connecting to a remove Microsoft server running MsSQL via PHP. The code looks something like:
$con = mssql_connect('0.0.0.0:123', 'user', 'pass')
or die(log_mssql_error(__FILE__, __LINE__, ...
0
votes
0answers
38 views
What's the best database for analysis/research applications, i.e. involving complex queries but few transactions? [closed]
I'd like to start a discussion on what people think what the best database environment (MySQL, MS SQL, PostgreSQL, ...) is for data analysis and research applications like encountered in empirical ...
5
votes
1answer
104 views
Failed copy job deletes all users
Since the progression of this was apparently somewhat difficult to follow the first time around:
I attempted a completely boring, been-done-a-thousand-times-before copy of a database using the copy ...
0
votes
2answers
36 views
Is there any way to connect to one server and utilize a linked server using Windows authentication and NTLM?
I currently have SQL Server 2005 (Server A) that has a SSAS 2005 linked server (Server B). The powers that be do not want to enable Kerberos authentication, so I'm stuck with NTLM.
The problem is ...
0
votes
2answers
29 views
Addtional configuration when deploying Data Tier Applications?
I'm starting a few new database projects and I'm attempting to create them at Data Tier Applications. There are two items I'm not able to find documentation for. I would like to set the db owner to SA ...
3
votes
2answers
67 views
sp_executesql adds statements to executed dynamic script?
The Question:
As far as I can tell, sp_executesql adds statements to the beginning of submitted dynamic SQL script. But, a SQL Profiler trace does not capture the extra statements, and neither does ...
6
votes
1answer
76 views
Strange behaviour DBCC Shrinkfile
I am attempting to run a dbcc shrinkfile in chunks of 1GB against a database where 95% of the data has been archived and deleted. I'm leaft with a 235GB file where 9GB is data/indexes. I want to ...
7
votes
2answers
510 views
Is it a bad practice to always create a transaction?
Is it a bad practice to always create a transaction?
For example, it is a good practice to create a transaction for nothing but one simple SELECT?
What is the cost of creating a transaction when it ...
0
votes
1answer
38 views
Restoring database backup file gives access error
I am running SQL server 2008 and trying to restore from a backup file.
Note: the backup file and folder and read/write access to "everyone". Running the command as "master"
Running
RESTORE ...
1
vote
0answers
56 views
SQL Server 2008 sp_send_dbmail [duplicate]
I'm using SQL Server's
sp_send_dbmail
to distribute mail. Everything is working fine; BUT I tried to test a bad email address and it always reports success; and nothing is in the failed sent items ...
0
votes
1answer
42 views
SQL Server: subscriber as publisher and hierarchical replication
In Oracle Streams one way replication from one DB to another is a basic block for many replication topologies (N-way, hierarchical, combined and so on), and changes could be captured and applied for ...
1
vote
3answers
41 views
Copy database to local from server [duplicate]
As I show , I have server database version-10.50.1600 and local database version-10.0.1600 .
How can I copy database (with all tables and data(s)) from server to local which has different version ? ...
4
votes
3answers
56 views
Check server activity with code
I would like to see the activity on of the SQL server. So I can run a query when the server load is low. I know there is an activity monitor in SQL server but my company doesn't want me to give the ...
2
votes
2answers
118 views
Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?
This question has probably been asked a dozen times but I couldn't find them here or at SO.
Can I attach/restore a SQL Server 2008 R2 database to my local SQL 2008 R2 Express instance?
-1
votes
1answer
64 views
validate where each parent intermediary is also a parent to itself [duplicate]
I want to validate where each parent intermediary is also a parent to itself. So this query should return invalid parents in SELECT If table has any.
I need to do is first of all get all parents ...
1
vote
3answers
62 views
Table clean up taking too long
I am selecting around 10 million rows which are invalid from table grid into ##grid_temp and deleting their related info from grid_info table. I am running this in a python script. It is taking more ...
1
vote
1answer
36 views
Statistical Analysis of Data that has to be done in an order?
Bear with me - that is the first time try that in SQL Server, normally I have been doing that on the front end ;)
I a implementing some analysis on time coded data series. This is not super ...
0
votes
2answers
28 views
Cannot see Green Button with white arrow in object explorer; DTC config problems?
I have SQL Servers across locations setup for replication. One of the SQL Server instances that I installed, running locally I can see the green button with the white arrow in the object explorer when ...
1
vote
1answer
85 views
SQL Server Memory for Backup Buffer
In SQL Server 2012 memory for backup buffer comes from buffer pool or non buffer pool (VAS)? Is this behavior changed between SQL server 2008 R2 and SQL 2012?
EDIT: Does MAX Server Memory ...
4
votes
1answer
124 views
Optimum configuration for 4 SSD drives
I would like to move a SQL Server database from a shared configuration with the web-server to it's own dedicated box. My current budget will allow me to put 4 disks together in an array with a single ...
