Matt Miller (4)

Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 6,486 total)

RE: CLR Table-Valued Function Example with Full Streaming (STVF)

I had attempted to use something like this to bring in data from an external file. One of those "ugly delimited" files, kind of delimited and kind of not,...

December 23, 2009 at 6:46 pm

#1096201
RE: @@identity bring back wrong number

@@identity has a lot of weaknesses which could cause this. If you're using 2005 you should probably be looking at the OUTPUT clause to get back the ID you...

December 23, 2009 at 12:51 pm

#1096120
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Hi Solomon -
This is definitely an interesting solution. I had noticed that ugliness of having to wait for the whole recordset to render before you could send it...

December 23, 2009 at 12:44 pm

#1096119
RE: Need help with date function please!!

Try this one on:
select day(getdate()) + --how far into this month are we
day(getdate()- day(getdate())) --how many days...

December 23, 2009 at 11:36 am

#1096090
RE: Are the posted questions getting worse?

Roy Ernest (12/23/2009)
I am working...Tomorrow I am OFF. Monday I will be back to work till Wednesday. Then I am off again. After that it will be in New Year...

December 23, 2009 at 11:11 am

#1096064
RE: A Fundamental Security Mistake

Sorry if I am being hard-headed in this case - but it would be a disservice not to mention this.
With Microsoft publishing tools like DaRT (Diagnostics and Recovery Toolset), please...

December 23, 2009 at 11:00 am

#1096052
RE: A Fundamental Security Mistake

Lynn Pettis (12/21/2009)
It isn't an end all or silver bullet. But that doesn't mean it isn't something that can be enhanced and further developed to enhance the security of...

December 21, 2009 at 4:33 pm

#1095170
RE: A Fundamental Security Mistake

Lynn Pettis (12/21/2009)
I know, and you have to explicitly code for the encryption, you can't just encrypt the database like you can with TDE in SQL Server 2008 EE. ...

December 21, 2009 at 2:11 pm

#1095108
RE: A Fundamental Security Mistake

CirquedeSQLeil (12/21/2009)
I agree with Steve. I would prefer to have extra security on the laptops - not to the level of fully encrypting the entire hard drive. Security...

December 21, 2009 at 1:18 pm

#1095060
RE: A Fundamental Security Mistake

I don't quite get what benefit there would be from TDE on Express. TDE only is useful for the data "at rest": if you have physicial access to the...

December 21, 2009 at 10:16 am

#1094914
RE: Closing out 2009 early?

Grant Fritchey (12/21/2009)
I'll be working both weeks. As a matter of fact, our job in these two weeks is to discourage development teams from "deploying before the end of the...

December 21, 2009 at 7:30 am

#1094754
RE: Are the posted questions getting worse?

GSquared (12/17/2009)
The Dixie Flatline (12/17/2009)
Is it just me, or is there a sudden frenzy of demands right at the end of the year?
Probably people trying to solve things before they...

December 17, 2009 at 2:13 pm

#1093769
RE: Have to use force recompile to get the SP to use indexes

GilaMonster (12/15/2009)
one-1016367 (12/15/2009)
Do you have any thoughts or prior experience regarding performance issues when using the recompile option?
It's the hammer approach. It'll work, but CPU usage will likely go...

December 15, 2009 at 9:46 am

#1092605
RE: Are the posted questions getting worse?

Jeff Moden (12/13/2009)
Matt Miller (#4) (12/13/2009)
Jeff Moden (12/12/2009)
Steve Jones - Editor (12/12/2009)
And here I think Barry would like this car
Man, I used to love "Spanky and his gang".
Oh - were...

December 14, 2009 at 11:11 am

#1092109
RE: Are the posted questions getting worse?

Jeff Moden (12/12/2009)
Steve Jones - Editor (12/12/2009)
And here I think Barry would like this car
Man, I used to love "Spanky and his gang".
Oh - were you madly in love with...

December 13, 2009 at 8:09 am

#1091660

Viewing 15 posts - 1,576 through 1,590 (of 6,486 total)