Viewing 15 posts - 136 through 150 (of 337 total)
I would say simply create a deserializer class in .Net and use it as a CLR obect to query the data through SQL Server.Of course this would come at expense...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 14, 2014 at 2:42 am
You say "..of average revenue by account... " so why are you averaging it based on fiscalyear.
Sum(revenue)/count(distinct fiscalyear) AvgByAccount
You could easily replace it with the Average function AVG(revenue) which will...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 14, 2014 at 2:36 am
Since you have posted the question in SQL Server 2012 TSQL category I assume you are using SQL Server 2012.If that's the case then you can simply use the EOMONTH...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
May 23, 2014 at 12:50 am
Appreciate the effort Micky.
It works perfect.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
November 13, 2013 at 11:50 pm
If you are already using Visual studio you can use GDR functionality that comes up VS 2008/2010 database edition.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2013 at 11:56 pm
Brandie Tarvin (8/2/2012)
....
LEFT OUTER JOIN DimTime dt1
ON ... (last update date column in staging table)
LEFT OUTER JOIN DimTime dt2
ON ... (Another date column in staging table)
LEFT OUTER JOIN DimTIme dt3
ON...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 3, 2012 at 5:00 pm
Not sure what would that manual intervention be and when in this scenario.
The only time I have to do any manual intervention in a DB mirroring is when I have...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 11:49 am
GilaMonster (7/29/2012)
Sachin Nandanwar (7/29/2012)
But if safety is OFF then any problem on the remote data center would not affect the principal as such.
The OP states that he wants automatic failover....
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 11:28 am
Lynn Pettis (7/26/2012)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 11:10 am
Theoretically yes it should work.
But for some reason if you have to re-run the snapshot agent and re-initialize the subscriber then I believe you will need to reset the compression...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 10:28 am
Does this work ?
....FROM #ddb_temp_DDB tdb
where not exists (select 1 from deposits_daily_balance ddb_t
where ddb_t.num_cue_s =tdb.num_cue_s and ddb_t.val_date_d = @t_date_d and ddb_t.reg_date_d = @t_date_d)
...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 10:13 am
Under which account is the sql server service running ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 4:50 am
shiv-356842 (7/26/2012)
Some data deletion was happend in our Environment.
Now i m planning to implementing AUDIT of the database & Server level any suggestions
In various level we have...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 4:47 am
First data compression works only with Enterprise edition.So make sure your edition is Enterprise.
Second compression is a property which does get replicated in replication.So if your table is compressed on...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 4:23 am
Kwisatz78 (7/26/2012)
So there would be some manual intervention involved in certain scenarios, but I think they are something we could live with.
I am actually hoping we...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 29, 2012 at 4:07 am
Viewing 15 posts - 136 through 150 (of 337 total)