This tag is for SQL Server 2008, major build version 10.00.xxxx.
1
vote
0answers
22 views
select top x works, but x+1 runs endlessly
Something happened to a table, that results in an endless executing select and I'm trying to figure out the reason.
What I tried and found out:
This runs endlessly:
select * from dbo.MyTable
As ...
0
votes
0answers
12 views
DBCC SHRINKFILE with logical file does not work, but it does work with file_id. Why?
We are using SQL Server 2008. I am trying to shrink a database file.
Using the logical file name results in error 8985, see below.
But using the file_id from sys.database_files does work.
The ...
0
votes
0answers
9 views
Databse Mail sending functionality not working on local system
I am using Database Mail functionality to send mail in Sql Server 2008 database via following sp:
EXEC sp_send_dbmail @profile_name='MyProfile', @recipients='[email protected]', @subject='Test ...
0
votes
0answers
12 views
Data Sharing between Client and Server Two Way [duplicate]
Please solve my query
One of my Silverlight application is running.
This Application is using one central database (sql server 2008) and three other client databases (sql server 2008) at other server ...
1
vote
1answer
18 views
Data sharing between client and server two ways
One of my Silverlight applications is running. This Application is using one central database (SQL-Server 2008) and three other client databases (SQL-Server 2008) in server other locations.
Our ...
0
votes
0answers
17 views
SQL Server 2008 log file growing and wont shrink. Hard Drive Space running out [duplicate]
I have a SQL Server 2008 database which has a log file (.ldf) with a size of 360GB and growing every day.
The .mdf file is only 25GB. The hard drive is 950 GB and has 150GB free space. I want to ...
5
votes
5answers
226 views
Find procedures that haven't been called in <n> days
We are deleting old stored procedures and tables.
How can I know what procedures haven't been called recently?
dm_exec_procedure_stats and dm_exec_query_stats aren't reliable, since they only return ...
2
votes
2answers
61 views
If I update a column record in a table, will indexes that do NOT have this column in it be affected?
In terms of performance if I have a table like so:
CREATE TABLE [TESTDATA].[TableA](
[Col1] [nchar](5) NOT NULL,
[Col2] [nchar](2) NULL,
[Col3] [float] NULL
CONSTRAINT [TableA_PK] PRIMARY ...
2
votes
1answer
33 views
Strategies for summary data in parent record based on detail data?
I have parent-child relationship as shown below. I need to find the first order date for each customer. Obviously, writing a query to do this is fairly straight-forward but it does require reading all ...
0
votes
0answers
13 views
Increasing time-out period for schema compare (windows server 2008, Sql Server 2008 R2 and VS2012)
I need to increase the time-out period for schema comparisson using visual studio 2012 to compare two sql server 2008 r2 database on a windows server 2008.
I believe this is somenthing I need to set ...
0
votes
0answers
27 views
Error 0xc02020f4: Data Flow Task 1: The column cannot be processed because more than one code page
SQL SERVER :
i executed an query and i got result of 8 million data. I have to create a table out of this result output.
SO i simply save the result out to table1.csv.
Now when i try to import ...
2
votes
4answers
24 views
What happens when I try to store more 8019 bytes in a SQL Server table row?
I read -
total fixed and variable length data are still limited to 8019 bytes total
But my data can possibly be more than this. What happens if it's more. Does it still store the data correctly?
...
0
votes
2answers
70 views
How to merge data sets without including redundant rows?
I think this must be a fairly common thing to do, but I haven't been able to find an example. It involves merging data that involves dates/times (or more generally any sequential values) without ...
-2
votes
0answers
59 views
How to enable auditing on TMG 2010, when using with SQL Server 2008 R2? [closed]
In my environment, i have TMG 2010 running which is feeding logs into SQL Server 2008 R2.
I have SIEM solution which uses JDBC to get the TMG logs from SQL Server through views.
This ...
7
votes
2answers
63 views
Does granting SA rights to a user in SQL compromise the OS?
I'm setting up a server that my company will be managing for one of our clients. This server runs an application that is managed by a 3rd party. We are responsible for the server and OS and the ...
1
vote
1answer
62 views
Does DBMS (e.g. of SQL SERVER 2008) use virtual memory?
Or in other words ... . Does the DBMS somehow circumvent the OS Cache manager and acccess the memory directly OR it lets the OS do its job, behave as a normal process and use the concept of virtual ...
3
votes
2answers
155 views
Reduce Clustered Index seek cost SQL Server 2008 R2
I am running a query and it have records in lakhs, it takes more than 20 mins to fetch data. After running the execution plan i noticed that clustered index seek cost can be be the reason. How can I ...
4
votes
3answers
78 views
How to see what is cached in memory in SQL server 2008?
Is there a way how to find out what is cached in SQL Server 2008 R2? I have found the following nice article: ...
3
votes
2answers
85 views
How large will the Transaction Log backup be?
I encountered a production database of 12 GB with a log of 90 GB. Full and differential database backups are made with a third-party backup tool, but no one is backing up the transaction log so it got ...
0
votes
1answer
31 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 ...
-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
3answers
64 views
memory used by Locks
I am kind of curious, one of SQL 2012 enterprise edition with 128 GB of RAM size of database is 370 GB and growing, amount of memory used by locks (OBJECTSTORE_LOCK_Manager) memory clerk showing ...
2
votes
1answer
44 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
311 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 ...
0
votes
1answer
19 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
1answer
64 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
33 views
Why am I getting a “login failed” when creating this linked server?
I'm creating a linked server from ServerA to ServerB, both of them are SQL Server 2008 servers. I need to create the linked server using a domain service account so that anyone will be able to utilize ...
0
votes
0answers
27 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 ...
0
votes
1answer
31 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 ...
1
vote
2answers
20 views
SQL Server 2008 sp_send_dbmail
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 ...
1
vote
3answers
38 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
53 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 ...
0
votes
2answers
26 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
75 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 ...
0
votes
0answers
31 views
Data deleted from replicated table
I have two servers (one publisher and other is subscriber). The replication is succesfully running for a long time. I am using transactional replication with updateable subscription.
Couple of days ...
0
votes
0answers
16 views
Data Type that automatically stores the DateTime of the last transaction done, SQL Server 2008 [migrated]
I need to add a new column to an existing table, so that whenever a new row is added, or an existing row is edited, this column will be filled with the exact date and time of the transaction. I tried ...
3
votes
1answer
43 views
Stopping SQL Server Agent: Effect on runnings jobs
On a server with MS SQL Server 2008 installed, we use the SQL Server Agent to schedule a large amount of SSIS-packages, all with unique schedules throughout the day.
Now and then, the server needs to ...
0
votes
2answers
41 views
Linked Servers pointing to same server (localhost) causing “Transaction context in use by another session” error
We are using SQL Server 2008. Normally our app that is using different databases distributed over the network and some of the stored procedures we call therefore make use of linked servers.
Now I ...
4
votes
2answers
94 views
When should tables NOT be compressed
We have two servers. One we just compressed, but I took over this little project and this guy says some tables are not good candidates. As with many others, performance is -critical-.
Is it accurate ...
2
votes
2answers
57 views
Combining data from two databases with same structure into one database
I have five SQL Server databases with the same schema in five different geographical locations. These locations send periodic backups to the central server which I restore in the five respective ...
9
votes
3answers
597 views
Updating a table with millions of records, its been 4 days
I am currently updating a table with millions of records, its been 4 days and query is still executing.
I checked the activity monitor its shows that query is running.
In event log there is no ...
1
vote
0answers
67 views
Troubleshooting a SQL Server instance that won't start
I've had a problem with one instance of SQL Server 2008 (the free version) not starting automatically. I always have to right click on the icon in the task bar and start it manually. It is set to ...
3
votes
4answers
436 views
Query without having to specify table's schema
I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg: erpadmin.tablename.
In the table properties it lists 'erpadmin' as the ...
1
vote
0answers
60 views
Search for multiple keywords related to separate columns on a single table
Imagine I have a table with the schema shown. Each of the columns represent a searchable collection that I would like to be picked up in the search. I am looking for a method that would derive the ...
2
votes
4answers
100 views
When should I use the shrink option
I have seen a lot of blogs stating that shrinking is not a good habit as it will reduce the performance of the system. I agree with all those things it will lead to side effects like fragmentation, ...
-1
votes
4answers
75 views
Dropping and recreating indexes [closed]
I most often come in a situation where the users move there database from one server to another and immediately after they move they face performance problems(slowness).
I somehow manage to rebuild ...
4
votes
2answers
109 views
Why do linked servers have a limitation of 10 branches in a CASE expression?
Why does this CASE expression:
SELECT CASE column
WHEN 'a' THEN '1'
WHEN 'b' THEN '2'
... c -> i
WHEN 'j' THEN '10'
WHEN 'k' THEN '11'
END [col]
...
0
votes
0answers
37 views
Cannot run job NT Authority\System error [duplicate]
Executed as user: NT AUTHORITY\SYSTEM. Login failed for user
'domainname\servername$'.
I receive this error when I try to run the job. I have full permissions; I have also tried to run this job under ...
0
votes
1answer
53 views
Migration to databases Domain Users do not have access
I migrated databases to new servers, however the applications that were previously used with the databases are failing to load. I have changed the connections and etc. The jobs also seem to be ...
