Viewing 15 posts - 2,326 through 2,340 (of 2,647 total)
Mvs2k11 (10/25/2011)
Here is the sample.CREATE PARTITION FUNCTION myRangePF1 (int)
AS RANGE LEFT FOR VALUES (1, 2, 3,4,5);
GO
CREATE PARTITION SCHEME myRangePS1
AS PARTITION myRangePF1
TO (test1fg);
Maybe a better question for me to ask is...
October 25, 2011 at 11:52 am
Click on your registered servers tab (or go to view, registered servers). Once you register servers you should be able to get to them as needed.
Thanks,
Jared
October 25, 2011 at 11:50 am
Can you please post the DDL for this table.
Also, to confirm... You would like to return the date for a specific account when that account's transactions have exceeded $100 (sorry,...
October 25, 2011 at 11:48 am
Can you paste the definition for your partition function and scheme please?
Thanks,
Jared
October 25, 2011 at 10:57 am
Ok, let's start a little slower... Can you connect via SSMS with the same user the application is using? Also, you say you developed this using VS2008, but in...
October 25, 2011 at 10:53 am
How are you using .NET to connect for this report? LINQ? Or ODBC?
Also, is the report an SSRS report or HTML? Or something else? (The settings are probably here...
October 25, 2011 at 10:47 am
Be careful here... Depending on the role and functions, you may be better off using REVOKE instead of DENY.
DENY overrides other permissions and will prevent access to the...
October 25, 2011 at 10:43 am
Let me see if I understand...
Day 11 you will switch out partition1 to staging table
truncate staging table
merge partition 1&2
add partition 11 (10)
Does this sound correct? Basically a sliding window...
October 25, 2011 at 10:38 am
Perry Whittle (10/24/2011)
jared-709193 (10/24/2011)
Yes, their view definition included the TOP and ORDER BY
don't know how many times it's been said but "Don't order by in a view" 🙂
A view...
October 24, 2011 at 10:23 am
Perry Whittle (10/24/2011)
jared-709193 (10/24/2011)
Yes, their view definition included the TOP and ORDER BY
don't know how many times it's been said but "Don't order by in a view" 🙂
A view...
October 24, 2011 at 9:54 am
Perry Whittle (10/24/2011)
jared-709193 (10/24/2011)
This is a SELECT ... from a view in which they used a TOP and ORDER BY.
are you saying the view definition is created upon a...
October 24, 2011 at 9:36 am
GilaMonster (10/24/2011)
October 24, 2011 at 9:22 am
Do your devs want to argue with someone who helped write the SQL engine?
They want to argue with anyone who blames their original code. They are caching a result set...
October 24, 2011 at 9:00 am
Aside from the original question... In a search to understand the way that queries work against our data I pose the following:
If rows in the table are stored logically in...
October 24, 2011 at 8:51 am
Thanks everyone! Its funny how I have missed some of the real fundamentals on my journey to DBA... I guess no time is better than the present to catch up!
Jared
October 24, 2011 at 8:29 am
Viewing 15 posts - 2,326 through 2,340 (of 2,647 total)