This tag is for SQL Server 2008, major build version 10.00.xxxx.
0
votes
0answers
11 views
How can I get my linked server working using Windows authentication?
I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs ...
3
votes
1answer
52 views
Central stored procedure to execute in calling database context
I am working on a customized maintenance solution using the sys.dm_db_index_physical_stats view. I currently have it being referenced from a stored procedure. Now when that stored procedure runs on ...
0
votes
1answer
42 views
Update performance: clustered versus covering index
I have a simple, 3-column table with about 50 million rows in it. This table gets about 5,000 inserts/updates per second, and perhaps 20 queries per second are executed against the table. The table ...
1
vote
1answer
38 views
Database denormalization: multiple rows into single column. How bad is it? [duplicate]
We have few join-heavy queries to our SQL Server 2008 database and in an attempt to optimize them I thought of having a view that would produce this
OrderID Number Traveller
1 102 ...
1
vote
2answers
56 views
How to find memory usage by table? [duplicate]
I want to discover how much memory is being used by each table. Is this information available in DMVs or elsewhere?
0
votes
1answer
55 views
SQL Server automatic transaction log truncation
Have looked through msdn but cant find answers to these:
Any help much appreciated:
In simple recovery mode:
Is there any TSQL or alternative functionality that will provide a notification either ...
3
votes
1answer
69 views
Insert performance with Geography column
I've been tasked with inserting data into a SQL Server table with a geography column. I've found that my times for doing inserts (same data 1.5 million rows) go up increasingly.
I started out with no ...
5
votes
1answer
78 views
SQL Server not giving back memory - staying at Max Server Memory setting
I'm the only one working on this server and followed documentation about optimizing SQL memory usage when I saw that SQL was using all of the memory available of the server.
One of the steps I did is ...
0
votes
3answers
36 views
Access to tables in SQL Server
I would like to know if there is a table where accesses to tables are saved, per user or per system.
I'm using both SQL Server 2005 and 2008.
3
votes
0answers
33 views
Severity 016 Backup virtual device fail
My backup on one of my servers is failing once a week. This is the alert I'm getting:
DESCRIPTION: BackupVirtualDeviceFile::PrepareToFreeze: failure on
backup device ...
2
votes
1answer
85 views
How to partition a very large table with limited db space?
I have a very big table. I want to partition it, but I cannot.
Database size: 1TB, Free space 200GB
Table:
Size: 165 columns (row lengh 4216 KB, no LOBs), 500 million rows, 600GB of data.
...
1
vote
2answers
65 views
How do I rollback a dropped table using log?
I have dropped a table from a SQL Server 2008 database.
How do I unroll the transaction log to recover the table and latest contents?
The database recovery model is "Full".
Is there any way or ...
1
vote
1answer
26 views
Can a partitioned table span on multiple files across different file groups?
In SQL Server 2008 and above, if a table is partitioned, can it span across multiple files across multiple filegroups?
Thanks
1
vote
2answers
37 views
DBCC CHECKDB command creating database file with same name but with space character in extension
I am running simple DBCC CHECKDB ('DBNAME') command on my machine every thing works perfect!
But when i execute same command on the live server the command executes without any error, but it creates ...
3
votes
2answers
70 views
Best high availability solution to avoid maintenance downtime?
We currently only have one production SQL Server 2008 server. Anytime we need to perform maintenance or install patches, it causes downtime as the server reboots. In addition, if the server ever ...
4
votes
4answers
77 views
Backup not creating a new file
I run a daily backup of my database through command prompt:
c:\sqlcmd -H localhost -Q "BACKUP DATABASE test TO DISK='c:\test.bak'"
But the new backup replaces the previous backup. Please tell me ...
3
votes
0answers
88 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 ...
3
votes
2answers
89 views
DBCC SHRINKFILE works with file_id but not with logical name
I am trying to shrink a database file but am running into errors.
Using the file_id from sys.database_files works, but using the logical file name yields an error.
The logical file name is the same ...
0
votes
2answers
69 views
Database Mail sending functionality not working on local system
I am using Database Mail functionality to send mail from a SQL Server 2008 database via following stored procedure execution:
EXEC sp_send_dbmail @profile_name = 'MyProfile',
...
0
votes
0answers
18 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 ...
2
votes
1answer
29 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
19 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
6answers
338 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
0answers
25 views
Cannot Delete FileStream Group from Sql Server 2008
We have migrated all our varbinary(max) column data to Azure Blob Storage and so we want to remove the old filestream columns that remain in our Sql 2008 database and the filestream filegroup but when ...
3
votes
2answers
67 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
14 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
50 views
Error 0xc02020f4: Data Flow Task 1: The column cannot be processed because more than one code page [closed]
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
33 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
75 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 ...
7
votes
2answers
83 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
67 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
183 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
107 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
93 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
43 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
73 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
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
353 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
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
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
35 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
39 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
39 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
27 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
42 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 ...
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 ...
