Viewing 15 posts - 2,236 through 2,250 (of 6,038 total)
Applying what you learn in the context of an actual project helps round it out and commit it to memory. Often times an employer will send staff to $,$$$ training,...
September 23, 2016 at 9:16 am
webrunner (9/23/2016)
Eric M Russell (9/23/2016)
Yet Another DBA (9/23/2016)
If we have problems with developers running feral in...
September 23, 2016 at 8:29 am
I think most DBAs would be more excited about RegEx integration than R. :doze:
September 23, 2016 at 7:41 am
Yet Another DBA (9/23/2016)
If we have problems with developers running feral in the database how many...
September 23, 2016 at 7:34 am
I'm sorry, but this is hands down the worst sample of SQL posted ever. It looks like a hex dump. Conversion error in Line 2? Where is Line 2? ...
September 22, 2016 at 12:33 pm
Brandie Tarvin (9/22/2016)
Thanks, guys. But you're all missing the point of my question.I withdraw it since no one understands what I'm asking for.
Would this work? First it checks if...
September 22, 2016 at 11:17 am
Technically speaking, we already have these things.
I picture a team of Agent Smiths (from the Matrix) seeking out rogue programs that seek to wreck havoc inside of the operating...
September 22, 2016 at 10:23 am
This should do what you need; first confirming that the table name matches pattern, next confirming that table is empty, and then dropping the table.
For some damn reason, SQLServerCentral throws...
September 22, 2016 at 7:46 am
Jeff Moden (9/21/2016)
Steve Jones - SSC Editor (9/21/2016)
Jeff Moden (9/19/2016)
To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.Look in the mirror
Thank you for...
September 22, 2016 at 7:03 am
Steve Jones - SSC Editor (9/21/2016)
Jeff Moden (9/19/2016)
To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.Look in the mirror
Now you're going to make...
September 21, 2016 at 12:44 pm
My advice for any experienced professional is never stay in a job where you feel bored or non-essential.
September 21, 2016 at 9:00 am
What you're describing sounds like some type of middle tier or data access layer. However, SQL Server has access control and event logging capability baked into it; I wouldn't use...
September 21, 2016 at 7:05 am
Luis Cazares (9/20/2016)
Eric M Russell (9/20/2016)
Luis Cazares (9/20/2016)
Here's an alternative that doesn't rely on undocumented procedures....
Yeah, but Microsoft doesn't officially support your method either. :satisfied:
Doesn't support or doesn't have...
September 20, 2016 at 2:43 pm
Luis Cazares (9/20/2016)
Here's an alternative that doesn't rely on undocumented procedures....
Yeah, but Microsoft doesn't officially support your method either. :satisfied:
September 20, 2016 at 2:05 pm
Whenever a process (whether it be a bulk insert, select, create index, or whatever) occasionally requires significantly longer duration to complete, it's usually due to blocking. When CREATE INDEX is...
September 20, 2016 at 1:04 pm
Viewing 15 posts - 2,236 through 2,250 (of 6,038 total)