Viewing 15 posts - 1,171 through 1,185 (of 2,462 total)
Another approach.
Create a database at reporting side. create views from all snapshot's tables in that database. and use that DB in your Application(reports) so there is no...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2010 at 1:14 am
Vinu verma (9/6/2007)
This previous DBA was the owner of this job.
i would suggest (recommended every where ) that we should use service account so that it wont be depended...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2010 at 11:47 pm
though i am not sure but i dont think standard edition supports MAXDOP
http://www.microsoft.com/sqlserver/2005/en/us/enterprise-compare-editions.aspx#bene
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2010 at 11:00 pm
1. i am second to ninja'a first suggestion to do it in batch format
2. how much data will be migrated ? huge data.....longer time.
3. also backup the log on...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2010 at 10:56 pm
Forget it ....thanks for your great support
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2010 at 4:10 am
MM. Thanks for quick response.
Actually
the output's sequence is not as you mentioned in WITH clause.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2010 at 4:05 am
thanks but one issue with the results
<Report xmlns:xsi="
got replaced with
<Report xmlns="
but i need
:xsi
text also.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2010 at 3:56 am
Craig Farrell (11/24/2010)
Bhuvnesh (11/24/2010)
gedda (11/23/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 24, 2010 at 1:12 am
gedda (11/23/2010)
Hi I am wondering if there is a way to get events from the database for DDL and DML operations without using triggers or is this a futile ambition?
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 24, 2010 at 1:02 am
Sample sql
USE TEMPDB
GO
select * from msdb.dbo.sysfiles
select * from master.dbo.sysfiles
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 24, 2010 at 1:00 am
S_Kumar_S (11/22/2010)
Are there any links which specifically address this topic and correctly too 🙂
NOt exactly what you want but YES ..some help is here http://sqlinthewild.co.za/index.php/2008/10/20/what-is-fragmentation/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 23, 2010 at 1:02 am
jolan.mahinay (11/22/2010)
he took the db to offline then he delete the file manually where it was stored and then he refresh the sqlserver there it shows a gray color..
it means...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 23, 2010 at 12:58 am
MysteryJimbo (11/18/2010)
Are you experiencing tempdb related constraints already?
No
MysteryJimbo (11/18/2010)
Have you configured additional files and preset their size?
no i am dealing with the same setting provided...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 18, 2010 at 9:20 pm
nigelrivett (11/18/2010)
Can you put these on different instances?
Nope 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 18, 2010 at 5:04 am
thanks but can you be more descriptive ? 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 12, 2010 at 12:51 am
Viewing 15 posts - 1,171 through 1,185 (of 2,462 total)