March 29, 2011 at 6:06 am
ALZDBA (3/29/2011)
bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Took a shot. π
Thanks, Johan... I appreciate it.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 29, 2011 at 6:07 am
bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Thanks, Ron. I didn't think of asking for help from "the thread".
--Jeff Moden
Change is inevitable... Change for the better is not.
March 29, 2011 at 6:53 am
I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.
I just spent about 45 minutes writing out a post to ask for assistance with a change tracking trigger design challenge I'm working on (the system involved is SQL 2008 Standard edition, so change data capture isn't an option, and the data I need to capture is being written by an ERP system where the SQL calls are embedded in code that I can't get to.)
As I was writing out the various pros/cons of the design problem and trying to make the whole situation coherent, I found myself writing my way through a MAJOR problem with one of the solutions I'd been considering.
Major enough that it answered the entire design dilemma by basically forcing me into the other option I had.
So I deleted that post, and decided to thank the various folks here who spend a lot of time providing assistance to others. Sometimes, you help just by being here - even when you don't know it.
-Ki
March 29, 2011 at 6:57 am
Kiara (3/29/2011)
I'm going to take a moment and thank you all yet again for help that you didn't know you just provided....
Major enough that it answered the entire design dilemma by basically forcing me into the other option I had.
So I deleted that post, and decided to thank the various folks here who spend a lot of time providing assistance to others. Sometimes, you help just by being here - even when you don't know it.
No problem, glad to help π π
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 29, 2011 at 7:15 am
Kiara (3/29/2011)
I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.I just spent about 45 minutes writing out a post to ask for assistance with a change tracking trigger design challenge I'm working on (the system involved is SQL 2008 Standard edition, so change data capture isn't an option, and the data I need to capture is being written by an ERP system where the SQL calls are embedded in code that I can't get to.)
As I was writing out the various pros/cons of the design problem and trying to make the whole situation coherent, I found myself writing my way through a MAJOR problem with one of the solutions I'd been considering.
Major enough that it answered the entire design dilemma by basically forcing me into the other option I had.
So I deleted that post, and decided to thank the various folks here who spend a lot of time providing assistance to others. Sometimes, you help just by being here - even when you don't know it.
Ki,
I (and I believe several others) have found that just the act of writing a good post that explains the problem will often guide you to the solution. I know it's happened for me several times.
So I'll reply back... thank you for writing such an excellent post that you solved your problem! π
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
March 29, 2011 at 7:25 am
WayneS (3/29/2011)
Kiara (3/29/2011)
I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.I just spent about 45 minutes writing out a post to ask for assistance with a change tracking trigger design challenge I'm working on (the system involved is SQL 2008 Standard edition, so change data capture isn't an option, and the data I need to capture is being written by an ERP system where the SQL calls are embedded in code that I can't get to.)
As I was writing out the various pros/cons of the design problem and trying to make the whole situation coherent, I found myself writing my way through a MAJOR problem with one of the solutions I'd been considering.
Major enough that it answered the entire design dilemma by basically forcing me into the other option I had.
So I deleted that post, and decided to thank the various folks here who spend a lot of time providing assistance to others. Sometimes, you help just by being here - even when you don't know it.
Ki,
I (and I believe several others) have found that just the act of writing a good post that explains the problem will often guide you to the solution. I know it's happened for me several times.
So I'll reply back... thank you for writing such an excellent post that you solved your problem! π
Yeah, Kiara writes such a great post that it solves the complex problem and then doesn't share it with us! : -)
Once you (Kiara) realized the solution you should have simply written the solution in and submitted it as an article instead of as a question. : -)
--------------------------------------
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
March 29, 2011 at 7:25 am
WayneS (3/29/2011)
I (and I believe several others) have found that just the act of writing a good post that explains the problem will often guide you to the solution. I know it's happened for me several times.So I'll reply back... thank you for writing such an excellent post that you solved your problem! π
Oh, it happens to me all the time. I just figured I'd bring it up this time. π
-Ki
March 29, 2011 at 7:27 am
Kiara, happens to me all the time. That's why I like hanging out with people smarter than me (and Alvin), some of it rubs off. π
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 29, 2011 at 7:38 am
Stefan Krzywicki (3/29/2011)
Yeah, Kiara writes such a great post that it solves the complex problem and then doesn't share it with us! : -)
Once you (Kiara) realized the solution you should have simply written the solution in and submitted it as an article instead of as a question. : -)
ROFL!!! I'm not sure how many people would actually care about the rationale behind the design of a set of triggers intended to capture an update date/time (and, the important part - where and how to store that date/time) for changes to specific fields across a dispersed set of ERP tables and the potential impact of those triggers on row locking in an OLTP database in which the application logic is built into the ERP solution where I can't get to it, the data is being pulled by another application that can't process data as fast as I can send it (hello, network I/O waits!), and where various transactions in the ERP system may update one, some, or all of the tables I need changed data from at any given time.
Oh - on SQL 2008 Standard, so no change data tracking option. π
It's sort of a one-off fairly specific situation, and while I think I have a solution that will juggle the needs of about six different users, programs, and situations here, I'm not sure that it has any application for anyone else... π
Plus, I haven't actually built the solution yet. I was still trying to decide which route to take. No plan survives first contact with the user community...
-Ki
March 29, 2011 at 7:43 am
Kiara (3/29/2011)
Stefan Krzywicki (3/29/2011)
Yeah, Kiara writes such a great post that it solves the complex problem and then doesn't share it with us! : -)
Once you (Kiara) realized the solution you should have simply written the solution in and submitted it as an article instead of as a question. : -)
ROFL!!! I'm not sure how many people would actually care about the rationale behind the design of a set of triggers intended to capture an update date/time (and, the important part - where and how to store that date/time) for changes to specific fields across a dispersed set of ERP tables and the potential impact of those triggers on row locking in an OLTP database in which the application logic is built into the ERP solution where I can't get to it, the data is being pulled by another application that can't process data as fast as I can send it (hello, network I/O waits!), and where various transactions in the ERP system may update one, some, or all of the tables I need changed data from at any given time.
Oh - on SQL 2008 Standard, so no change data tracking option. π
It's sort of a one-off fairly specific situation, and while I think I have a solution that will juggle the needs of about six different users, programs, and situations here, I'm not sure that it has any application for anyone else... π
Plus, I haven't actually built the solution yet. I was still trying to decide which route to take. No plan survives first contact with the user community...
It isn't necessarily the specific solution that people would be interested in there, but the thought processes that went into determining the solution and the various methods and techniques that go into the solution. Parts of a solution can frequently be stolen borrowed learned from a large, complex, specific solution and be applied to other problems as a part of their solution.
--------------------------------------
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
March 29, 2011 at 7:58 am
All,
I'm having a bit of a cluster issue. Would love advice from people with cluster experiences, if you have time.
http://www.sqlservercentral.com/Forums/Topic1085532-146-1.aspx
March 29, 2011 at 8:16 am
So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook) video storage?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 29, 2011 at 8:20 am
jcrawf02 (3/29/2011)
So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook) video storage?
The big problem I see with the "cloud" is bandwidth. Is it practical to think that you'll get reliable transfer rates in enough places to allow it to work? And if more and more people start using high bandwidth technology, will it bog down the network to the point it is unusable?
Plus, once you've got all your video stored in the cloud, what do you do when you can't connect to get it back? Connectivity is more reliable than it used to be, both wired and wireless, but neither is 5 9s yet.
--------------------------------------
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
March 29, 2011 at 8:25 am
Stefan Krzywicki (3/29/2011)
jcrawf02 (3/29/2011)
So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook) video storage?The big problem I see with the "cloud" is bandwidth. Is it practical to think that you'll get reliable transfer rates in enough places to allow it to work? And if more and more people start using high bandwidth technology, will it bog down the network to the point it is unusable?
Plus, once you've got all your video stored in the cloud, what do you do when you can't connect to get it back? Connectivity is more reliable than it used to be, both wired and wireless, but neither is 5 9s yet.
That's a good point, since likely a lot of places you'd really want this would be out-of-the-way spots.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 29, 2011 at 8:30 am
jcrawf02 (3/29/2011)
So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook) video storage?
Not in my part of the world. To stream a 1080p needs at least 200kB/s upload speed (that's with fancy compression), not even going to calc the cost of that much data transfer up and down.
Maybe in the US, Europe and Far East (Hong Kong, Korea, etc)
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
Viewing 15 posts - 25,126 through 25,140 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply