Viewing 15 posts - 2,296 through 2,310 (of 5,685 total)
abatej (11/18/2011)
What I tell non technical people: computer programmer or a computer guyLast person I told that too asked if I could jail break her iphone...
I love that...
Me: "I...
November 18, 2011 at 2:25 pm
andyron (11/18/2011)
Please give some inputs for an newbie.
The plan is to redevelop 10 PL/SQL package hundred page code, without changing the func. and the specifications, can we remove all...
November 18, 2011 at 2:23 pm
chris 81958 (11/18/2011)
I just read the "Forum Etiquette" section that you recommended. I can see how that would help a lot for both the poster and the helper....
November 18, 2011 at 1:10 pm
Since there seems to be a lack of replies I might as well supply my opinion... I'm not willing to share my salary, even in a generic vote. Besides,...
November 18, 2011 at 1:07 pm
Probably could whip something up, but I'm going to need similar schema/data samples as you originally provided for HRIS_Employee, HRIS_AbsenseHistory, HRIS_Vacation, why UnFiltered is using only the last entry logging...
November 17, 2011 at 5:20 pm
What background software are you using to pass the logins around for hops? Kerberos? Probably just needs to get itself refreshed from the primary system.
November 17, 2011 at 5:14 pm
SpringTownDBA (11/17/2011)
http://blogs.msdn.com/b/craigfr/archive/2008/08/05/partitioned-indexes-in-sql-server-2008.aspxhttp://blogs.msdn.com/b/craigfr/archive/2008/07/15/partitioned-tables-in-sql-server-2008.aspx
Tasty and chewy, thanks SpringTown. Gods I need to get caught up with things in 2k8... Skip Scan... really?! Wouldn't seem so odd if I didn't...
November 17, 2011 at 4:54 pm
Thanks Ninja, I was also hoping to shorten up the endless scroll when I came back to this though. 🙂
No wonder that thing takes two minutes, gyeah. Between...
November 17, 2011 at 4:27 pm
SpringTownDBA (11/17/2011)
What column is the table partitioned on?Sql logically treats the partitioning column as a leading column of the indexes when building query plans.
Hunh, news to me. ...
November 17, 2011 at 4:15 pm
agiangone (11/17/2011)
Table has 400,000,000 records and 1.4M are null but on key_2 having value 2 only 40,000 are null so the percentage is about 50% on the total but...
November 17, 2011 at 4:13 pm
Mitch2007 (11/17/2011)
I decided to go with a Passthrough query created in VBA so that I could pass the Dates (which is stored on the source table...
November 17, 2011 at 4:08 pm
MyDoggieJessie (11/17/2011)
November 17, 2011 at 4:04 pm
Mitch2007 (11/16/2011)
BETWEEN CONVERT (varchar, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 15), 112)
AND CONVERT (varchar, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 14), 112)
It comes to a grinding halt....
November 17, 2011 at 3:24 pm
Can you give me an average row size and NULL in key_1 percentage? going to build a local test-case.
November 17, 2011 at 3:00 pm
Sean Lange (11/17/2011)
I call it job dating. Both sides get a predetermined amount of time to see if they like each other before "going steady". 😛
Great, thanks Sean. Now...
November 17, 2011 at 2:52 pm
Viewing 15 posts - 2,296 through 2,310 (of 5,685 total)