Viewing 15 posts - 26,791 through 26,805 (of 59,102 total)
Bhaskar.Shetty (5/23/2013)
Any select query with aggerate function requires a GROUP By clause with columns list to be grouped on.
Not quite true. Many of the aggregate functions can be used...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:33 pm
lnardozi 61862 (5/21/2013)
Which is to say, what CAN'T you do in an inline tvf if you really really want to?
Effective and high performance running totals in a pre-2012 environment, for...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:16 pm
krit (5/23/2013)
Jo Pattyn (5/23/2013)
Have no experience with realtime replication. How realtime is it (ns, ms, minutes...). Is it realtime part oneway (oracle+msql) to ms sql server?Triggers have a disadvantages
They need...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:05 pm
Knowledge Draftsman (5/23/2013)
However, I think, that too many workers don't know how to do their jobs without the aid of a computer.
Ironically, I've found a great number of workers...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 4:03 pm
raadee (5/20/2013)
Not sure if I replied on your post Jeff.It was meant for the creator of the thread.
Ok... if the creator of the thread has databases like mine, that method...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 3:29 pm
Wouldn't a query with a GROUP BY/ROLLUP have been easier?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 3:22 pm
Sean Lange (5/23/2013)
create proc..
AS
if @strAddress3 = ''
set @strAddress3 = NULL
[/code]
Or just...
SELECT @strAddress3 = NULLIF(strAddress3,'')
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 3:18 pm
mdm72 (5/24/2013)
We backup our tlogs every 20 minutes, when the job fails (reason unimportant) we are notified via email/txt. Has anyone executed a scripted...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 1:31 pm
zombi (5/22/2008)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 24, 2013 at 1:28 pm
Abu Dina (5/21/2013)
We have a tall table that contains 2.6 billion rowsTable structure:
Gosh. A couple of people have mentioned a couple of things seriously wrong with this already but...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 23, 2013 at 7:34 pm
krit (5/23/2013)
Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you
I don't see how real time replication of data from an Oracle Server...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 23, 2013 at 6:31 pm
Sigerson (5/23/2013)
Needs no tweaking of permissions or access, other than turning xp_cmdshell ON and OFF.
I'm just curious... why do you turn xp_CmdShell OFF? Since anyone (including an attacker)...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 23, 2013 at 6:26 pm
jennigirl (5/23/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 23, 2013 at 6:07 pm
GSquared (5/21/2013)
Jeff Moden (5/21/2013)
Lowell (5/21/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 21, 2013 at 1:19 pm
Lowell (5/21/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 21, 2013 at 12:21 pm
Viewing 15 posts - 26,791 through 26,805 (of 59,102 total)