@ypercubeᵀᴹ Just tested sys.sql_expression_dependencies on SQL Server 2005 and it is not there. Perhaps you should add that to your answer since OP mentioned 2005 in the question.
@AndriyM Yes, I verified that filtered indexes were added in 2008.
But you are saying that there is no MSDN page for 2005 and earlier versions, right? So, even for some feature that existed in 2000-2005, the MSDN page will say "starts with 2008"?
@ypercubeᵀᴹ It appears you can access them using a direct link with (v=sql.90) in it but they are not accessible from Other Versions (so I was wrong there).
This question appeared in the reopen queue today. It's hard to know why someone has voted for this question to be reopened. It could be that something has changed with the product and the question is now relevant or maybe the people who voted to close missed something.
Would it make sense to req...
I have a table in my database with few simple columns and one binary column. The primary key of that table is an integer type.
The problem I am facing is that auto-incremented primary key column had hit its maximum limit +2147483647. Means that table have around 2 billion records in it. Due to ...
@MaxVernon Partly my humour (comment abuse!), but partly serious as well. That would be a sort of meta comment, rather than genuinely "minor or transient information". I purposely omitted the comment option from my answer, because someone would have to clear it up.
I guess my question kind of shows that I only hang out here where the regular reviewers are quite few and a reopen would likely be reviewed by mostly the same people who voted to close it in the first place. It seemed to make sense at the time but I can see how it could be detrimental to the site.
@JamesAnderson Yeah it could be made to work here because we're quite small, all nice, and generally good at "following the rules". I can't imagine SE would do it just for us, which raises the question of how well it would work across the network. I guess I had that in mind when writing my answer as well.
One StackOverflow does not down vote and close as much.
For sure SO is more friendly on Answers. I get down voted here a lot and hardly ever get down voted SO. I still drop by.
An answer today from new user today was vote to close an hour after a request for some more information. You h...
@PaulWhite I was just trying to be funny, but apparently it's not working. Present company excluded is an idiom which means "the criticism you have just made does not describe the people who are listening to you now". I was one of the original VtC people ;-)
@MaxVernon Yes I'm familiar with it, just not how it applies. I was pointing out that different people voted to close, leave closed, and reopen - i.e. that the original close was in fact reviewed by different people.
@JamesAnderson Votes are private. If I had to guess, I'd say a vote to reopen without an edit means they wanted a review of the validity of the close. After all, it only takes 5 people to close, not the whole community. Different eyes and all that. — Paul White ♦30 mins ago
I'm not surprised the question was closed actually. It is rather basic, unless there's some super-interesting detail none of us are aware of. I suspect not, given the answers and comments.
Seems ok for me recently. The odd 10s wait to connect, but only very occasionally, and not that unusual. The transient errors bug me more than anything.
it's been taking 10 to 15 seconds to complete loading for me. Maybe I'm allowing some crap javascript to run or something else I normally have turned off.
@ypercubeᵀᴹ Goodness knows what it is. General latency is no worse than the distance would suggest, but just now and then I get "Connecting..." in the Chrome status bar for an extended period. I changed to Google DNS a while back, but.
@ypercubeᵀᴹ Just dba.se. I don't use other SE sites enough to notice. Non-SE sites are always fine.
In other news, an offer appeared in my letterbox (physical) for 1Gbps Fibre today. I am trying very hard to avoid taking that up just to post annoying speedtest results.
1Gbps Internet! I remember when that was impressive for a wired LAN.
@bluefeet No, I reported the much more annoying problem instead. This one doesn't really bother me, and I wouldn't expect SE to spend time debugging my setup/ISP.
@MaxVernon Seems a creative use. No idea if it is valid. Hope so!
@PaulWhite Individuals can't have it around here (except the lucky bastards that made the test project). You have to have a company and pay a lot of money because they need to open the road/pavement and add a cable especially for your connection
@PaulVargas sorry, Codd is the guy who is responsible for much of the normalization theory. Codd is a homophone of Cod (the fish). Tuna is another type of fish. So, to complete the explanation of the joke, "normal form of tuna" is just a play on words.
once upon a time, there was a joke made by a very intelligent user in a chat room. Sadly, the the other users didn't realized that it was a joke (could be that the user was unfunny, or the crowd not sophisticated enough, or both), so they replied as it was a serious comment. Then, the user explained his joke in length, making it clear that it was indeed funny. Many of us realized then that jokes are funnier when explained at length
@Lamak as long as someone explains it at length. You did a pretty good job of that. I just wish you could have put in some @AaronBertrand style allusions.
I have a table in my database with few simple columns and one binary column. The primary key of that table is an integer type.
The problem I am facing is that auto-incremented primary key column had hit its maximum limit +2147483647. Means that table have around 2 billion records in it. Due to ...
One StackOverflow does not down vote and close as much.
For sure SO is more friendly on Answers. I get down voted here a lot and hardly ever get down voted SO. I still drop by.
An answer today from new user today was vote to close an hour after a request for some more information. You h...
I have 4 tables:
CITY
(
city_id PRIMARY KEY,
city_name,
state,
total_staff,
travel_code,
is_capital_city
);
DEPOT
(
dep_id PRIMARY KEY,
capacity,
capacity_used,
mgr_name,
depot_type,
audit_year,
city_id,
Foreign Key (city_id) References CITY
);
MANUFACTURER
(
manu_id PRIMARY KEY,
manu_name,
...
