This tag is for SQL Server 2008, major build version 10.00.xxxx.
0
votes
0answers
34 views
I need advise on if I should rebuild my index [duplicate]
I have a SQL Server 2008 Standard server on full mirror (safety). I reorganize all indexes weekly. I am looking into rebuilding a few indexes to improve performance. I ran DBCC SHOWCONTIG on my ...
0
votes
2answers
27 views
Do I need to have enterprise server in order to have multiple data sources in SSRS
I am currently running a single server setup of SSRS on MSSQL Server 2008 R2 Standard Edition and would like to know if I can have multiple data sources in this type of setup.
The reason I ask this ...
0
votes
2answers
45 views
How should I structure my time based index?
So I have this table in SQL Server 2008. Let's just say it's called TimeSheets.
Now, that table has two columns I am concerned with.
TimeSheetDate and UserCustomerKey.
TimeSheetDate is a ...
0
votes
1answer
14 views
How to fix SQL Server instances with different builds on same server?
I have a Windows 2008 box and there are 5 instances of SQL Server 2008 Standard installed.
After that, SQL Server service pack patched.
Weird thing is: the builds for those instance are different. ...
0
votes
2answers
45 views
Join two subquery in hql
How can I write this sql query in as hql:
select count(distinct s.id) as prepaid, count(distinct ss.id) as postpaid
from (select * from subscriber where subscriber.ispostpaid=0) s
join (select * ...
0
votes
3answers
55 views
Backup from Server1 and restore it to Server2?
IF we have two Servers installed with SQL Server 2008 instances,
Server1 has three drives C, D and E with 100, 500 and 500 GB respectively
and Server2 has three drives C, D and E with 100, 300 and ...
2
votes
1answer
121 views
Are there advantages to using temporary tables over derived tables in SQL Server?
I read the derived tables have better performance than temporary tables, but anyway many SQL Server developers prefer the second ones. Why?
I must do queries with large data (millions records) and I ...
-5
votes
0answers
31 views
need sql query for below tables [closed]
select * from City
select * from Doctor
select * from Nurse
select * from Patient
CityId CityName
1 Bangalore
2 Delhi
3 Chennai
DId Cityid
A 1
B 1
C 2
D 3
NId Cityid
E 3
F 2
G ...
1
vote
2answers
77 views
Move a huge databases from one SQL Server to another
I have customers databases located on my SQL Server 2008 machine. The size of these databases are around 300 GB. I would like to move them all to another SQL Server 2008.
Is there a way to shrink ...
3
votes
1answer
68 views
Simple method to setup SQL Server for development access
I've created a virtual development box and installed SQL Server 2008 with mixed authentication. Then I connect to SQL Server via SQL Server Management Studio using my Windows account but when I try to ...
3
votes
1answer
41 views
sql server service broker queue pass parameter to stored procedure
Stored Procedure
Create PROCEDURE [dbo].[InitServiceLog]
(
@name varchar(max)=null
)
AS
BEGIN
SET NOCOUNT ON;
insert into [AdventureWorks].[dbo].[ServiceBroker_Log](Service) ...
1
vote
2answers
49 views
Convert Login from Windows Authentication to SQL Server authentication?
I have an account that is setup for Windows authentication. The account is used by SSRS for running reports and has various permissions in multiple databases. I need to convert this account to use SQL ...
0
votes
1answer
63 views
Log shipping - switchover and failback
We are doing a planned failover and switch back from the primary to DR with mirroring. We do not have a separate monitor instance.
Please help me with the following
1. Is it possible to switch back ...
2
votes
0answers
39 views
Maintaining Referential Integrity with a Filestream enabled database
We have a production database which is filestream enabled and has grown, within a year, to about 20Gb as it stores documents. On many occasions we need to bring the live data back to UAT or Dev ...
1
vote
2answers
43 views
SQL Server Linked Servers and Remote Statistics
I'm trying to get a better understanding of how SQL Server uses statistics on remote SQL Servers (e.g. a Linked Server). I understand that the user needs db_owner/db_ddladmin rights to be able to use ...
