This tag is specifically for the 2008 version of Microsoft SQL Server.
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
3answers
83 views
How to handle update or insert situations
From time to time my stored procedures looks like
create procedure handle_data
@fk int
,@value varchar(10)
as
begin
if exists (select * from my_table ...
1
vote
0answers
59 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 ...
3
votes
1answer
93 views
SQL Server 2008 Cluster Across Two VMWARE Hosts
Vmware ESX 5 from a Vcenter
Two Windows 2008 R2 VMs
I am attempting to setup Failover Clustering using two VMs from within a Vcenter. Each virtual machine resides on a seperate physical host ...
2
votes
1answer
59 views
Can I delegate SQL Agent rights without granting sysadmin rights?
I'd like to give a user the ability to administer SQL Agent jobs. According to the doc page, I can do this by granting the "appropriate" roles on msdb. I've granted all three SQLAgent% roles, but ...
0
votes
0answers
46 views
T-SQL Script for segmenting data into finer categories based on percentage measure in another table
I have a SQL Server 2008 R2 database with two tables. The first table - Shops - has a list of establishments and the number of shoppers it attracts segmented by criteria A (2 categories) and B (2 ...
2
votes
2answers
46 views
I want to create a mirror in SQL Server 2008, but the database is in the status “restoring …”
I'm trying to create a mirror in SQL Server 2008, and did the following:
On the principal server
USE master;
GO
ALTER DATABASE Test
SET RECOVERY FULL;
GO;
BACKUP DATABASE Test
TO DISK = ...
-1
votes
1answer
44 views
Odd syntax error when creating view with SCHEMABINDING [closed]
I've been working with SQL Views for a while now, and I recently read that something that I want to do requires that one of my views be created with schemabinding. That sounds fine, but I get a ...
0
votes
1answer
45 views
Why is CDC capture failing due to a missing dbo principal
I am having a problem running the CDC change capture job against some of my test databases.
The error message I'm getting is the following:
Executed as user: NT AUTHORITY\NETWORK SERVICE. Cannot ...
0
votes
2answers
120 views
Get most recent 100 records from the database
I am using SQL Server 2008, we have one database which contains 150 tables. We have introduced systimestamp DATETIME column in every tables. We do update this column with current timestamp whenever ...
0
votes
0answers
38 views
mySQL- large database
I need guideline to setup DBMS(MYSQL or SQL Server 2008). The database size is expected upto 80-100GB in next few months. One main table will contain textual content like essays. Can MySQL handle such ...
0
votes
2answers
252 views
How to import data from a pair of .mdf/.ldf files into a MySQL database [duplicate]
I have two Microsoft SQL Server database files named "xxx.mdf" & "xxx.ldf" and I want to import that database into MySQL so I can run queries against it using phpMyAdmin. How would I go about ...
-1
votes
1answer
40 views
what kind of owner to defined when creating Sql server DB for web site? [closed]
what kind of owner to defined when creating Sql server DB for web site ?
I am trying to create db and i need to select owner.
my db will serve aspnet web site and I wonder witch owner will be safe to ...
2
votes
3answers
280 views
How to Handle TimeZone Properly in SQL SERVER?
I have some issue which needed to be fixed quickly. My local development server is in middle east. But my production server is in UK. Now, I need to show the date to user to thier timezone. For ...
1
vote
0answers
60 views
Login failed for user sa ssis 2008
I have a problem with ssis2008
I built a package that have a connection with SQL Server authentication (username : sa).
When I use BI, it works fine but when I build a job that used this package it ...
5
votes
2answers
59 views
Turning on TF610 in SSIS
I have a simple SSIS package that loads a dummy file that contains 100000 rows. Each row is around 4k long, one int column and one long text column. I'm trying to test TF610 when loading this data ...
0
votes
0answers
51 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
1answer
37 views
Can I deactivate log shipping jobs without raising errors?
I've set up log shipping from Server A to Server B. I then set it up from B to A when B was the primary.
I've reverted back to A being primary and disabled the backup, copy and restore jobs ...
1
vote
2answers
110 views
SQL Server 2008 Group by 30 minute Time Intervals
I have a SQL select statement which produces the following results, and I need to define it so that we can group the data based on 30 minute intervals of time and provide the sum of Revenue and Nbr of ...
0
votes
1answer
111 views
Stored Procedure Create Table from Variable with Variable Constraint
I have managed use a store procedure to create a copy of a table with a variable name. But I am struggling to understand how to incorporate a constraint into the stored procedure.
The problem:
The ...
1
vote
4answers
91 views
SQL Server 2008 DB Performance on single disk
I have a database in SQL Server 2008 with around 20 GB in size. And it is increasing rapidly.
Somehow I can not add multiple independent harddisks to increase IO performance.
If a add large table ...
2
votes
5answers
212 views
SQL Server 2008: How to send an email when a step in a SQL Server agent job fails, but overall job succeeds
I have a SQL Server job with 6 steps. Steps 5 and 6 must be run regardless of any failures in the first four steps, so these first four jobs are set to skip to step 5 if they fail.
However, if steps ...
6
votes
1answer
178 views
How to trace SQL queries which are crashing SQL Server
We have a SQL Server 2008 database server (it happens to be running under MS Failover Clustering, but I don't think that is relevant here).
Our application runs Hibernate for DB access, and since we ...
13
votes
6answers
520 views
Why should an application not use the sa account
My first question ever, please be gentle. I understand that the sa account enables complete control over a SQL Server and all the databases, users, permissions etc.
I have an absolute belief that ...
0
votes
1answer
56 views
Restoring multiple differential backups SQL Server 2008 [duplicate]
Over the bank holiday the backups failed on a db the full has been restored and now I have several differentials to be restored on top.
Could someone give best method or do I restore just ...
0
votes
0answers
44 views
Maitenance Plan - job failed
I created simple plan
with my access to Ms SQL Server 2008 R2
but job failed with exception
Date 31. 3. 2013 4:00:01 Log SQL Server Agent (Current - 17. 3. 2013
5:00:00)
...
2
votes
1answer
122 views
Bitmask Flags with Lookup Tables Clarification
I've received a dataset from an outside source which contains several bitmask fields as varchars. They come in length as low as 3 and as long as 21 values long. I need to be able to run SELECT queries ...
1
vote
1answer
83 views
Setting DATEFIRST to 6
I would like to set FIRSTDATE to 6 (ie: saturday), i have read that to change it parmanently i could set the default language of the login to one of an existing language from the sys.syslanguages and ...
3
votes
1answer
126 views
Automatic database file creation based on database file size in SQL Server 2008 R2
Now i am using SQL Server 2008 R2 database for data logging. The name of the database profile is MASTERDB. That profile has one data file called MASTERDB.mdf and one log file called MASTERDB_log.ldf. ...
0
votes
1answer
16 views
How to create via sql and detect via ERRORLOG SQL Server 2008 Deadlocks
I am designing a monitoring program using HP Sitescope SIS.
The goal is detect deadlocks.
In doing so, I created a deadlock on an existing but nearly unused SQL Server 2008.
I used the following ...
-1
votes
2answers
45 views
Restore Replicated Database on Different Server
I want to Restore the replicated database on different server and resume the replication from there. I have distributor and subscriber running on the same server. when i restore my replicated database ...
0
votes
0answers
77 views
code -2068578302 Status of package 'SQL Server 2008 R2 Express' after install is 'InstallFailed'
Trying to install SQL Server 2008 R2 with bootstrap but failed. Install.log as below. Please help.
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: ...
2
votes
0answers
19 views
SQL Server 2008 R2 SP1 - Tempdb “Available free space” showing negative value [duplicate]
Please help as this issue is driving me nuts...
Tempdb has four data files & one log file. They are all located on the same dedicated drive.
When I right click on tempdb in SQL Server Management ...
4
votes
2answers
278 views
SQL Server 2008 R2 SP1 - Tempdb “Available free space” showing negative value
Please help as this issue is driving me nuts...
Tempdb has four data files & one log file. They are all located on the same dedicated drive.
When I right click on tempdb in SQL Server Management ...
12
votes
1answer
171 views
ISO Week vs SQL Server Week
Okay so I have a report that does a this week vs last week comparison and our customer noticed that their data was "funky". Upon further investigation we found it was not doing weeks correctly ...
4
votes
1answer
64 views
How long does it take to do RESTORE WITH NORECOVERY
I am in the unfortunate situation of having to do a database restoration.
My full backup was at 9.30pm (157MB) and there were incrmentatl backups at 11am and 3pm. The incremental backups are less ...
2
votes
2answers
72 views
Differences Between Two Different Create Index Commands
Are there differences between these two scripts? Or would all of the extra tokens/attributes (ie: NONCLUSTERED, WITH..., etc...) for the 1st script be defaults in SQL Server 2008 for the 2nd script?
...
1
vote
0answers
70 views
SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB
I'm having a heck of a time with this issue and can't figure out what is wrong. I'm not sure how long this tiny DB has been in 'encryption_state = 2' from query:
SELECT * FROM ...
3
votes
5answers
219 views
Stored Procedures under Source Control, best practice
I am currently using Tortoise SVN to source control a .NET Web Application. What would be the best way to bring our SQL Server stored procedures into Source Control? I am currently using VS 2010 as my ...
1
vote
1answer
54 views
Would I lose data if I change a column from varbinary(8000) to varbinary(max)?
Is there any data loss if a table is being altered to change an existing column from varbinary(8000) to varbinary(MAX)?
6
votes
1answer
180 views
Landed as BI, but databases are a big WTF, what to do?
Maybe a duplicate, but I believe my case is a bit different. From one of the answers I got to this post on SQL Server Central that also comes handy too but is not quite the same scenario: 9 Things to ...
1
vote
1answer
104 views
Error on creating database in SSMS
I am using SQL Server Management Studio 2008. I am connect to localhost and I want to create a database. When I click on New Database, type the name and click ok, I get the message:
Index was ...
4
votes
1answer
106 views
In Change Data Capture (CDC), why lsn is used instead of timestamp?
I am learning to use CDC in SQL server 2008, I have read that LSN is always incremented and is based upon timestamp, so why LSN is required, if it is calculated from timestamp which can be used as ...
1
vote
1answer
84 views
SQL Server 2008 search joining query
I have two table as one is the message table and another one is messageUser table.
Now i need to check before insert a new row.
for example,
M_MessageMessageId=========
...
2
votes
2answers
69 views
Can the OUTPUT clause create a table?
I'm doing an update like this:
UPDATE dbo.Table1
SET BirthDate = b.BirthDate
FROM Table1 a
JOIN Table2 b
ON a.ID = b.ID
And I want to use the OUTPUT clause to back up my changes.
UPDATE ...
1
vote
1answer
65 views
SQL Server replication conflicts after migration from 2000 to 2008
I got a suggestion over at Stackoverflow to post here....greatful for any and all help.
Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
7
votes
3answers
228 views
SQL Server Sandbox
I'm attempting to set up a sandbox for our report developers to their work in. My current plan is to "reset" the database every evening but I'm not sure how to go about doing so. What I mean by reset ...
2
votes
6answers
372 views
SQL Server split mdf into multiple files
I have a database called example.mdf with a total size of 1GB which suffers from performance issues. I checked the allocated hardware and it is higher than required, I double checked the design and ...
5
votes
1answer
67 views
RESOURCE_SEMAPHORE_QUERY_COMPILER waits in Microsoft SQL Server 2008 Enterprise
Could fragmented indexes on Microsoft SQL Server 2008 Enterprise cause RESOURCE_SEMAPHORE_QUERY_COMPILER waits?
The last two weeks one of our applications has had downtime due to ...
0
votes
2answers
116 views
Resume Logshipping after Primary database restored
We have Database (D1) as a primary database and Log shipping setup to the secondary database called (LS_D1). Now what we are doing is taking backup of D1 database and restore it on D2 database. We do ...
