Brandie Tarvin

Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 9,707 total)

RE: Looking to update old code

I'll keep this all in mind. Thanks, everyone.

September 27, 2016 at 4:55 am

#1903284
RE: Are the posted questions getting worse?

HELLO! This is my new "must have".

September 26, 2016 at 7:17 am

#1903076
RE: Are the posted questions getting worse?

TomThomson (9/24/2016)
Jeff Moden (9/23/2016)
Luis Cazares (9/23/2016)
Someone needs a course on how to write basic DML. Or maybe I'm just grumpy this week.
No... you're not grumpy. As a matter of...

September 26, 2016 at 7:16 am

#1903075
RE: Looking to update old code

Eric M Russell (9/23/2016)
Brandie Tarvin (9/22/2016)
Eric M Russell (9/16/2016)
If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other...

September 23, 2016 at 12:28 pm

#1902895
RE: Looking to update old code

The Dixie Flatline (9/22/2016)
Brandie Tarvin (9/22/2016)
The Dixie Flatline (9/15/2016)
If some of your joins are to tables that simply provide descriptions, I'm a big fan of converting those joins to inline...

September 23, 2016 at 11:36 am

#1902878
RE: Are the posted questions getting worse?

YIKES! Not only is Microsoft changing the patching for Win 7 & 8.1, but hackers have gotten to the White House.
And we're having mini-meltdowns at work where everyone is...

September 23, 2016 at 10:40 am

#1902857
RE: Cleaning up "rotten" tables - need help with code

Phil Parkin (9/22/2016)
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.
Yep, I am totally puzzled...

September 22, 2016 at 10:39 am

#1902547
RE: Cleaning up "rotten" tables - need help with code

mister.magoo (9/22/2016)
I would:
Change the process so it doesn't generate empty tables.
Yeah, already doing that.
Open Object Explorer Details, right click column headers and include "Row Count" in the display
Sort list by...

September 22, 2016 at 9:59 am

#1902525
RE: Cleaning up "rotten" tables - need help with code

Thanks, guys. But you're all missing the point of my question.
I withdraw it since no one understands what I'm asking for.

September 22, 2016 at 9:58 am

#1902522
RE: Cleaning up "rotten" tables - need help with code

Phil Parkin (9/22/2016)
I'd write a query to identify (only) the empty tables. Add a column to the query which returns the 'DROP TABLE ...' statement, for the selected table.
Execute the...

September 22, 2016 at 7:32 am

#1902458
RE: SQL Agent Job Shows Running for Days, but Not Really Running

jerry-621596 (9/15/2016)
I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.
Seems like the mystery runs deeper...

September 22, 2016 at 6:35 am

#1902437
RE: Looking to update old code

Eric M Russell (9/16/2016)
If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other transactional databases, then consider more...

September 22, 2016 at 6:33 am

#1902436
RE: Looking to update old code

The Dixie Flatline (9/15/2016)
Also, get rid of scalar functions in queries wherever possible. Inline table valued functions perform wayyy better.
Hmmm. Not really using scalar functions. Using a...

September 22, 2016 at 6:31 am

#1902433
RE: Looking to update old code

The Dixie Flatline (9/15/2016)
If some of your joins are to tables that simply provide descriptions, I'm a big fan of converting those joins to inline table-valued functions. ...

September 22, 2016 at 6:28 am

#1902431
RE: Are the posted questions getting worse?

And in other tech news, the European Union is thinking about free wifi. Sorry UK Threadzians. You have been Brexited out of the plan.
Plus, has Apple ruined the emoji?

September 21, 2016 at 11:43 am

#1902255

Viewing 15 posts - 1,426 through 1,440 (of 9,707 total)