Viewing 15 posts - 2,326 through 2,340 (of 14,953 total)
Can you run an SQL task before the Merge, after the staging load, that checks for rows in the staging data that would violate the constraint?
Update dbo.MyStagingTable
set RowCheck = 'fail'
where...
- 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
January 9, 2012 at 1:55 pm
How about snapshot replication instead? That captures a point-in-time of the data, and you can easily suspend that whenever you need to.
- 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
January 9, 2012 at 1:48 pm
This method would have to go through the whole of both tables each time it's run, even if you just change one value in one table.
I would use an Output...
- 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
January 9, 2012 at 1:46 pm
I have an Android tablet instead, so I don't use an iPad for anything at all.
If Android tablets count for this (resurrected) discussion, I use mine for work, play, reading...
- 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
January 9, 2012 at 1:36 pm
It really depends on what you're loading and how.
For example, if table A depends on table B, and you're just loading table A in your process, you could run a...
- 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
January 9, 2012 at 1:30 pm
I joke about it, but I also have more books than I have shelf-space, and not all from pre-ereader days. I still buy RPG books hard-copy (of course), and...
- 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
January 9, 2012 at 1:21 pm
It also assumes all data in the database will never be either consumed or modified by anything outside the scope of your application.
And it might not even prevent injection. ...
- 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
January 9, 2012 at 12:28 pm
GilaMonster (1/9/2012)
Steve Jones - SSC Editor (1/9/2012)
jcrawf02 (1/9/2012)
GilaMonster (1/9/2012)
Ninja's_RGR'us (1/9/2012)
There was a time I loved fiction, got any books to recommend?
Yes
http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/
http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx
We both have 2010 posts as well if you feel...
- 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
January 9, 2012 at 12:09 pm
Steve Jones - SSC Editor (1/9/2012)
Jack Corbett (1/9/2012)
Roy Ernest (1/9/2012)
- 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
January 9, 2012 at 12:07 pm
Profiler is quite resource-hungry, but server-side traces barely impact the server at all.
I haven't tried filtering by a specific proc name. I sometimes filter by a particular database.
Can you...
- 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
January 9, 2012 at 11:07 am
I set mine up just by using blogspot.com. Took about 10 minutes to get it up and running.
I think it's had all of about 5 visitors since I created...
- 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
January 9, 2012 at 11:04 am
Are you familiar with using the ranking functions in T-SQL? Row_Number(), Rank(), Dense_Rank() are the functions.
Build a query that uses those to generate the numbers you need, then join...
- 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
January 9, 2012 at 10:59 am
SQLRNNR (1/9/2012)
SQL Kiwi (1/9/2012)
GSquared (1/9/2012)
Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.
You don't think 'Aaron Aardvark'...
- 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
January 9, 2012 at 10:54 am
You could output to a file and run that. Any reason to do so instead of just executing it as dynamic SQL?
If you really insist on the output a...
- 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
January 9, 2012 at 10:51 am
Select the states and cities, then use Cross Apply (or Outer Apply) to get the top 30 percent for each.
Is that what you're trying to do?
Something like this:
select state, city,...
- 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
January 9, 2012 at 10:46 am
Viewing 15 posts - 2,326 through 2,340 (of 14,953 total)