Viewing 15 posts - 1,036 through 1,050 (of 5,678 total)
It looks like you may already have a calendar table in GPM. Can you give us the DDL and a few sample rows from that?
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
October 29, 2012 at 12:03 pm
Update for the testing I've done.
I can completely rebuild these packages without issue from scratch, but I cannot alter an existing one that's been upgraded from 2k5. Something is...
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
October 29, 2012 at 11:58 am
tanvishriya (10/26/2012)
I am using WildCard % in one of my queries. Weird is that when the wildcard % is used at the first place its creating lot of performance...
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
October 26, 2012 at 4:18 pm
Welcome to the forums. 🙂
First, no, you can't call a procedure in-line of another SQL statement to run per row. Those are functions in SQL Server, and they're usually...
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
October 26, 2012 at 2:32 pm
If you setup test data this becomes easier, check out the first link in my sig for what we'd prefer when we do code assistance.
In general, what you're dealing with...
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
October 26, 2012 at 2:29 pm
mishka-723908 (10/26/2012)
they compromise the natural (primary key)
I'm not being explicit enough. I'm trying to determine HOW the data is used, not merely the logical build (I can see it's...
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
October 26, 2012 at 12:52 pm
Roughly, you're looking at ~120 bytes/row. What are Door_no and Period, and is there any additional indexing?
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
October 26, 2012 at 12:27 pm
WayneS (10/25/2012)
Anyone still alive out here? 3 days with no comments... that has to be a record for The Thread.
Crushed between workload, personal life, and illness. Haven't had much...
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
October 26, 2012 at 12:23 pm
*groans*
Out of sheer morbid curiousity, I decided to shred this.
Standard Admin:
1. SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures)
(repeated later) Assist development staff with...
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
October 26, 2012 at 12:21 pm
mishka-723908 (10/25/2012)
For ease of moving them around if needed. What would you recommend given the size and amount of data?
You mentioned 40 mill records per partition, but what's row-width and...
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
October 25, 2012 at 4:09 pm
Allen,
Short form, Truncate Table requires an exclusive lock on the table schema (SCH_M) to activate, which means that it can be the only thing accessing the table when it tries...
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
October 25, 2012 at 4:02 pm
DataDog (10/22/2012)
2 days 2 years 2 millenia won't make any difference as they are all linked in a chain!
Eventually everything in a shipment/order would have to age past the 2...
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
October 22, 2012 at 11:10 am
I personally only tend to archive data that's over 2 years old, so at that point the shipments involved and all orders SHOULD be filled. I'd put in some...
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
October 22, 2012 at 10:26 am
Bkokster (10/20/2012)
Doing it this way takes way too long
Well, if it's too long, the cursor is probably where you are getting stuck, you may just be unfamiliar with a few...
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
October 22, 2012 at 1:53 am
Typically, using either SCOPE_IDENTITY() function or OUTPUT clause on the initial insert.
Can you post the DDL for the tables and an example of what data you're trying to insert? ...
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
October 22, 2012 at 1:43 am
Viewing 15 posts - 1,036 through 1,050 (of 5,678 total)