Viewing 15 posts - 661 through 675 (of 5,678 total)
You don't. You've opened the floodgates.
However, there's a hardware mechanism you can use if you've got a centralized N-Tier and these users aren't running the app off their PCs....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 3:12 pm
SQL_Surfer (5/21/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 2:30 pm
Look up using the delimitedsplit8k function here. It creates a table you can join against instead of using an IN clause and will protect you from injections.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 2:28 pm
Run a profiler trace against the target box and see what the query is sending down explicitly. It might be a simple difference in the dateformat defaults on the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 2:15 pm
Dynamic report builders are tricky and nasty. If this doesn't have to be real time data, check into SSAS cubes and Powerpivot for your power users.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 2:08 pm
On a side note, my gaming rig still runs Vista (yes, it's that old). It's about to be upgraded in the next month or two which means I'm getting...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 1:43 pm
No, it's not exposed externally.
You can call external components from within an SSIS package that way, but you can't invert the process. There's no API/Driver components that will let...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 1:28 pm
Debbie,
In this particular case, I think you'd be better off learning a bit of scripting. Don't worry, it won't be much. A Script Source component which does...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 21, 2013 at 1:28 pm
As far as I know, there's no DDL trigger that can pickup a TRUNCATE, unfortunately. You'll find the list here:
http://msdn.microsoft.com/en-us/library/bb522542(v=sql.105).aspx
Now, as a workaround, you could create an instead of...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 6:31 pm
What's the error, and can you describe the linked server you're calling mysqlapp?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 6:20 pm
Someone had to do it, it's not automatic.
If you're curious, check out this blog from Kimberly Tripp:
When did SQL Server stop putting indexes on Foreign Keys?
MSDN also discusses the value...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 6:15 pm
ScottPletcher (5/13/2013)
If you want to check for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 5:34 pm
Jeff Moden (5/13/2013)
Brandie Tarvin (5/13/2013)
Duh. Forgot there is a record 4 line which is the last line of the file. Anyway, sample data attached and CREATE TABLE code as follows:
Heh......
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 5:09 pm
It'll only matter if you start doing query hint overrides... which you should avoid in 99% of circumstances, so yeah... won't matter. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 4:31 pm
Brandie Tarvin (5/13/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 4:02 pm
Viewing 15 posts - 661 through 675 (of 5,678 total)