This tag is specifically for the 2008 version of Microsoft SQL Server.
2
votes
2answers
70 views
Linked Server Risks
I'm implementing a new feature which requires data from databases on multiple servers. I just need to union data from all these servers and sort it. The two options that come to mind are:
Use linked ...
2
votes
1answer
75 views
Prevent users from using power pivot excel connections to a database
A couple of weeks ago my boss connected to our production database via excel and was able to query the database. Because of how we're doing security to the database (AD groups) he should have access ...
3
votes
1answer
99 views
How does order of index affect performance in SQL Server?
I am wondering how does order of index affect performance (ASC, DESC) ? If it affects, why ? And which order should I choose ?
0
votes
1answer
65 views
Is there a way to truncate table that has foreign a key?
Is there a way to truncate table that has foreign keys ? Delete and reseed can take too long. Is deleting and recreating keys only way ? If so is there a tool that does this ?
1
vote
1answer
111 views
SQL Server stored procedure working when run manually, not running from SQL Server Agent
I have a procedure that runs fine using the execute command in SSMS, however putting the same command in a job gives the following error.
line 9, character 9, unexpected end of input
The code ...
1
vote
2answers
86 views
sql server 2008 execution plan different on two production servers
We have two servers running SQL server 2008 R2, with identical databases, where we implemented a datawarehousing solution. The cube processing operation was taking a VERY long time in one of the ...
1
vote
0answers
113 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 ...
2
votes
3answers
125 views
SQL server disk write queue dramatically grows sometimes
I have SQL Server 2008 and a single database with full recovery model. Usually, the queue length is less than 1. But sometimes it grows up to several thousands (3000!!) for a few seconds. At this time ...
-3
votes
2answers
107 views
read multiple values from same column [closed]
how to read multiple values in same column and campare it with the same table id and other table to get its record..
i have a table with column name
pid ,authors ,citing papers
...
2
votes
0answers
103 views
Cannot connect to SQL Server 2008 after updating the service pack
After updating, whenever I start the service of the server in configuration manager, it always stops then.
And I found the error in the log
2013-04-13 19:08:19.63 spid7s Error: 15174, ...
0
votes
2answers
78 views
which sql server edition is good for practice [closed]
Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
6
votes
1answer
175 views
How do I optimize large table so queries that target only recent data perform optimaly?
So I have this table that is ever growing. Most queries are targeting just recent data, say one month old. I suppose this is common problem but I have no idea how it can be solved.
I am open to ...
0
votes
0answers
6 views
The 'Data-based filtering for mining models' feature is not included error [duplicate]
The 'Data-based filtering for mining models' feature is not included in SKU Standard 64 bit edition.
I have upgraded to Enteprise Edition but I still get the error.
Why is that ? Is there something ...
0
votes
0answers
21 views
The 'Data-based filtering for mining models' feature is not included
The 'Data-based filtering for mining models' feature is not included in SKU Standard 64 bit edition.
I have upgraded to Enteprise Edition but I still get the error.
Why is that ? Is there ...
5
votes
3answers
272 views
What could cause the wrong ID to be inserted?
I have a SQL Server 2008 server (build 10.0.5500). Earlier this week I ran this on a table that already had data in it:
delete from dbo.table
go
dbcc checkident('dbo.table',reseed,0)
When the ...
7
votes
2answers
112 views
Increasing the decimal precision abruptly increased the size of table
I have a table like:
CREATE TABLE grid_rows(
[grid_row_id] [int] NOT NULL,
[grid_column_id] [smallint] NOT NULL,
[decimal_val] [decimal](18, 6) NULL,
[datetime_val] [datetime] NULL,
...
-3
votes
1answer
411 views
How database administrators can see my requests to MSSQL server?
I'm a MS SQL 2008 user. I have access to some tabes. I need to request few colums from table as I usually do. But I need to do it onse (for example) in 5 seconds and system administrators shouldn't ...
2
votes
1answer
77 views
Windows native backups makes SQL Server think that databases backup has been done
community.
I've Windows Server 2008 R2 which hosts few virtual machines.
One of machines is Windows 2008 R2 server with SQL server 2008 R2 Express installed.
Here's the thing:
I wrote a script that ...
1
vote
1answer
60 views
dead lock when updating
Update Operation.TrTable
Set RecordId = RecordTABLE.newRecordId
From Operation.TrTable tr
Inner Join (
SELECT r.Id AS newRecordId, r.KeyM AS MappingKey
From ...
2
votes
1answer
78 views
SQL 2008: Why is *any* user, with minimal permissions able to restart/stop the SQL instance through Management Studio
So I'm on a project that I need to help admin SQL 2008 .
I'm coming from a MySQL background.
Why is it that a basic user, with the most basic/default permissions, through Management Studio is able to ...
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
84 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
68 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
101 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
60 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
47 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
46 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
122 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
278 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
331 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
62 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
63 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
53 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
38 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
125 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
117 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
239 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
200 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
527 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
60 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
134 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
87 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
130 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
18 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 ...
