September 11, 2012 at 1:33 pm
I posted a question here: http://www.sqlservercentral.com/Forums/Topic1357535-2799-1.aspx?Update=1 about automating file downloads in SQL Server. I would appreciate any help or suggestions or even just "This is How We Do It."
Thanks, ..
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 13, 2012 at 2:11 pm
Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 13, 2012 at 4:14 pm
GilaMonster (9/13/2012)
Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx
We'll see. I hope I can be of help.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:39 pm
SQLRNNR (9/13/2012)
GilaMonster (9/13/2012)
Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspxWe'll see. I hope I can be of help.
He's in over his head...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 13, 2012 at 4:44 pm
That seems to be the case. Maybe we recommend hiring a consultant?:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 14, 2012 at 5:27 am
Do we recommend the consultant before or after someone posts "Take the database offline. Delete all the .MDF and .LDF files. Recreate only the .MDF and .LDF files that you want to keep and bring the database back online." ?
September 14, 2012 at 5:38 am
Tangently related to the post under discussion, I've found there are a lot of rookie writers who think that when you tell them "this won't work" that you are not talking about them, because obviously "this" worked for someone else, so they should be able to get away with doing "this" even though more experienced writers, agents, editors and publishing professionals are telling them that "this" doesn't work.
For instance, we were discussing the penchant for new writers to post their work on their blog for free. And a bunch of us kept saying, "Don't do that. You're giving away your first publishing rights and a lot of houses will never buy your book if it's available elsewhere for free." But the rookie in question insisted that there were several people who got high-dollar publishing contracts for the stuff they put up on their blog. I don't remember all the examples he cited, but Julie & Julia was one of them.
He completely missed the point that all the examples he cited were authors who never intended their blogs to become books. They were writing on a subject they felt passionate about and happened to get book offers based on that fact.
Which goes back to the whole "Well, someone posted this advice, so it must be geniune and correct, because it worked for someone. Why should I not listen to it?" syndrome.
How do we fix that perception? And how do we make people understand that a solution that works in one circumstance may not work in other circumstances and generally is not appropriate to universal application?
September 14, 2012 at 6:18 am
Anyone get the increasing feeling people are looking for the 'eazy button'?
Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2012 at 6:43 am
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 14, 2012 at 6:47 am
I couldn't find an answer to this guy's question: http://www.sqlservercentral.com/Forums/Topic1359181-391-1.aspx?
I always thought that "," and "CROSS JOIN" were identical, but he found a case where they aren't. "," generates a column-binding error while "CROSS JOIN" doesn't.
Anyone with any better answers want to chime in on it?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 14, 2012 at 6:48 am
Stefan Krzywicki (9/14/2012)
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
You're doing it wrong.
DBCC Timewarp (# of columns / (pi * # of tables) + 8 )
The 8 is there because everyone knows there are 8 KB per page.
September 14, 2012 at 6:53 am
Brandie Tarvin (9/14/2012)
Stefan Krzywicki (9/14/2012)
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
You're doing it wrong.
DBCC Timewarp (# of columns / (pi * # of tables) + 8 )
The 8 is there because everyone knows there are 8 KB per page.
I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 14, 2012 at 8:13 am
Stefan Krzywicki (9/14/2012)
Brandie Tarvin (9/14/2012)
Stefan Krzywicki (9/14/2012)
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
You're doing it wrong.
DBCC Timewarp (# of columns / (pi * # of tables) + 8 )
The 8 is there because everyone knows there are 8 KB per page.
I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.
Nah. It's secret now, but since it won't be secret when the year 1900 roles around again, it's okay to post details. In the past-future-imperfect tense, of course.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 14, 2012 at 8:16 am
GSquared (9/14/2012)
Stefan Krzywicki (9/14/2012)
Brandie Tarvin (9/14/2012)
Stefan Krzywicki (9/14/2012)
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
You're doing it wrong.
DBCC Timewarp (# of columns / (pi * # of tables) + 8 )
The 8 is there because everyone knows there are 8 KB per page.
I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.
Nah. It's secret now, but since it won't be secret when the year 1900 roles around again, it's okay to post details. In the past-future-imperfect tense, of course.
Excellent, so from then on I will be about to have been going to done so.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 15 posts - 37,816 through 37,830 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply