Viewing 15 posts - 2,236 through 2,250 (of 6,035 total)
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
Provide examples of the most problematic values you're trying to convert.
September 20, 2016 at 11:47 am
For this, you can leverage sp_MsForEachDB. It will execute the specified batch of T-SQL across all databases. For each iteration, the token ? will be dynamically substituted with the database...
September 20, 2016 at 11:32 am
I know what you're talking about. If you have a stored procedure that accepts multiple parameters for performing searches (it seems every CRM type application has one), then dynamic SQL...
September 20, 2016 at 10:43 am
Viewing 15 posts - 2,236 through 2,250 (of 6,035 total)