Viewing 15 posts - 256 through 270 (of 458 total)
SQL!$@w$0ME (11/28/2013)
For dev environment d: for app, e: for data, f: for log, g: for tempdb and h: for backup is it too much im asking for?
If each of...
November 29, 2013 at 12:00 pm
Biggest skill I need is how to find stuff on SQLServercentral.com
November 22, 2013 at 11:51 am
Life-long techno-nerd, started with computers in college on a Univac 9300, programming in FORTRAN on 80-column punch cards. Stayed with computers as they developed, wound up in a museum's IT...
October 23, 2013 at 11:05 am
jonysuise (10/17/2013)
Check this post. Might help.http://carlosbercero.com/post/?post=Writing_a_CLR_Stored_Procedure_on_SQL_Server
But back to the original question, actually. Do you know if any of these methods are faster? That was my interest in this, to try...
October 17, 2013 at 11:20 pm
jonysuise (10/17/2013)
Check this post. Might help.http://carlosbercero.com/post/?post=Writing_a_CLR_Stored_Procedure_on_SQL_Server
Okay, thanks, I'll try that. I use Access, not VS, but the principles should be similar.
October 17, 2013 at 2:29 pm
jonysuise (10/17/2013)
Use master..xp_cmdshell or CLR stored procedures instead.master.dbo.xp_dirtree is an undocumented and unsupported procedure.
I was trying to avoid xp_cmdshell for all the security problems. Also, dirtree provides the file...
October 17, 2013 at 12:55 pm
One DBA (me) supporting one developer (me) servicing around 30 users, running 3 servers. Yes, I'm up to *** in alligators.
October 4, 2013 at 9:21 am
I don't normally need a very large log. This size is an aberration, created only when I do the occasional large import, and combine it with a malfunction of my...
September 16, 2013 at 2:35 pm
ScottPletcher (9/16/2013)
On some disks, the autogrowth can result in a less contiguous log file, which can also...
September 16, 2013 at 11:44 am
Amen to that. Rote memorization has its place, but that's not the highest skill level you should want in an employee, or contractor. I rarely even bother trying to memorize...
September 10, 2013 at 7:01 am
GilaMonster (8/23/2013)
pdanes (8/23/2013)
How are they getting that fragmentation?
I suppose during the import process. This table is not copied - it's part of a design change, and is newly generated from...
August 23, 2013 at 3:34 pm
GilaMonster (8/23/2013)
August 23, 2013 at 3:32 pm
GilaMonster (8/23/2013)
August 23, 2013 at 3:27 pm
GilaMonster (8/23/2013)
Hi Gail. I was hoping to meet you in person during SQL in the City last month, but I got involved in a scuffle with the passport control police...
August 23, 2013 at 3:16 pm
MyDoggieJessie (8/23/2013)
August 23, 2013 at 2:08 pm
Viewing 15 posts - 256 through 270 (of 458 total)