@swasheck Basically they give you licenses for MS products for 'internal use' and dev/test. The name is from when they used to mail you a binder full of the physical CDs.
No, the identity column is not the partitioning key. Your approach is what I would do absent any input from more experienced engineers. If I get no responses, I'll try it and post whether it worked or not. — David Mercer1 min ago
Good movie I watched last week end: Red Cliff. Directed by John Woo, based on a historical Chinese battle around 230 AD. It's like watching live action Dynasty Warriors.
I have some ASP.NET code that has an SSRS report control on page. The web application is hosted on a different server than where SSRS is hosted. The problem I'm having is when I pull up the report in Internet Explorer the date picker control is not showing the calendar and if I try to pull up the...
If you execute the view it should stay cached in memory, if it is too big try creating a (temp?) table. — JLampon1 min ago
I don't even know where to start
I am just saying create the results table once for all possible results and when you do the query you can use the parameters without the joins. — JLampon1 min ago
We don't spend too much time talking about our code of conduct; the rules are few and fairly straightforward, and most people abide by them, most of the time. But some of these guidelines, while obvious to our core community, are often unknown to or misinterpreted by newcomers.
One of the oldes...
The main problem I see with any of these efforts is trying to force people to read them, never mind hope that they understand them or care enough to actually abide by them. I know users with six-figure rep that either don't know 90% of that text or refuse to demonstrate that they do. — Aaron Bertrand7 secs ago
I'm not saying don't do them, I just don't want people to have some high expectations that making better FAQ/help content is magically going to fix the site. Newbies are going to continue to be demanding and sensitive, and experienced users are still going to tell them to RTFM. — Aaron Bertrand9 secs ago
Well this might be a start, probably not the nice output you'd hope for (and it produces two resultsets):
EXEC sp_helplogins N'floob';
But it does work on SQL Server 2000. If you want to try and replicate some of the functionality in the procedure, you can see how it's checking for permissions...
I am looking though some tests about T-SQL querying for SQL Server 2012. I have the following question with the correct answer colored in green:
My question is why answer A. Inline user-defined function cannot be the answer here as it can filter the result set based on supplie parameters and c...
@ypercube I'm curious whether there is an equation or mathematical model that describes how many bins are needed to create a histogram that describes a distribution accurately.
Or one that, given a number of bins, states how accurately a distribution can be described with that number of bins.
It's related to the maximum number of steps/bins for a statistic in SQL Server being limited to 200. I'm thinking about trying to find a way to check whether a table can be described well with a maximum of 200 bins.
Because it really sucks when the statistics are wrong no matter how up to date they are, and you can't get some queries to use filtered stats. :/
In the bin packing problem, objects of different volumes must be packed into a finite number of bins or containers each of volume V in a way that minimizes the number of bins used. In computational complexity theory, it is a combinatorial NP-hard problem.
There are many variations of this problem, such as 2D packing, linear packing, packing by weight, packing by cost, and so on. They have many applications, such as filling up containers, loading trucks with weight capacity constraints, creating file backups in media and technology mapping in Field-programmable gate array semiconductor chip design...
Just guessing, math was what I referred to as my GPA killer
R - Problem: to find the optimum number of non-uniform bins to show a range of data points.
I have a bunch of data points (let us assume different prices of different mobiles). I need to categorize these mobile phones into some categories (based on the price). The bin size (in this example refer...
James, It probably has to do with the volume of the data. If for example, a datetime column spans over tens of years, every one of the 200 bins will span months. If the query has a condition for a very short period, the statistics will only be guessing on the number of rows that match.
It could be all the data are in midday or midnight or the first day of months - and not equi-distributed inside a bin.
@ypercube Yes, that's the type of situation where I run into problems with stats: lots of distinct values (often datetime or datetime + something else) with widely varying counts.
I'm not really sure if there is much of a practical application as a DBA to what I'm asking. I think it might be useful to have a shortcut to being able to say the data just can't be described well in 200 steps.
If nothing else, because then you know it's time to look past the wrong estimates (assuming filtered stats aren't an option) and focus on something else.
@ypercube Hm, sorry to cut in on your conversation but would that mean that querying a fairly large table (some data archive, for instance) for a couple of years' worth of data might potentially result in a more efficient QP (relative to the number of rows returned) than querying for a week interval?
@AndriyM I guess it could. If the optimizer expects hundreds of rows it may choose a different plan than for a few rows (assuming it's not a simple query but has some more joins or other complications). Then, if the actual rows are very few, we could have that the plan is not optimal, right?
@ypercube And vice versa. In SQL Server plans that underestimate rows tend to be biased toward choosing operators like the nested loop join that don't perform well (compared to other join operators) on huge numbers of rows.
Well this might be a start, probably not the nice output you'd hope for (and it produces two resultsets):
EXEC sp_helplogins N'floob';
But it does work on SQL Server 2000. If you want to try and replicate some of the functionality in the procedure, you can see how it's checking for permissions...
I am looking though some tests about T-SQL querying for SQL Server 2012. I have the following question with the correct answer colored in green:
My question is why answer A. Inline user-defined function cannot be the answer here as it can filter the result set based on supplie parameters and c...
