For your initial situation, it seems you tried something like this:
CREATE DATABASE YAFnet ON (FILENAME = N'C:\sql_data\YAFnet.mdf')
FOR ATTACH;
However, this method requires both an mdf file and an ldf file. Otherwise you get an error message similar to:
Msg 5120, Level 16, State 101, Lin...
I have a view in Sql Server 2008 that when performing just a:
SELECT * FROM [Table]
Will return roughly 40000 rows by 130 columns. Here are 6 runs with client statistics on (roughly 7 seconds average):
Let's just assume those times are fine, the problem comes when a filter is applied. Here ...
First off, that name. Boris Baryshnikov. So dramatic sounding
secondly, this:
> In a nutshell - statistics on a column are decoupled from the filtered index (auto generated – and then only updated based on total row counts, and not row counts narrowed by the filtered index predicate.
What other statistics are there to keep about a table?
not views, not indexes, but the table itself. And then, what other stats are there to keep about an index?
There are statistics for each index. The auto update of these stats are based on the % of data churn in the entire table. So, in theory, a filtered index could quadruple in size and, if it's a small enough subset of the table, it will have completely out of date stats.
I'm not sure what you mean with your questions... where does anyone talk about statistics for the table? The comment you quote is talking about stats on a column vs. stats on a filtered index.
You can, yes, but not everyone does. SQL Server also automatically creates statistics for indexes you create. Thepis is what it uses to derive cardinality estimates, row counts, etc.
Instead what I'm going to do is go read up on running node.js on my local OSX so I can play in my browser
because once we get into cardinality estimation by automated engines that have to maintain and update that information by magic, and the tall double I'm drinking with my blogreading, I'm just gonna go with "yeeeeeah" and let that be your magic for now ;-)
I have a problem.
I have a table that has around 80-100million records in it. In that table I have a field, that has stored from 3 up to 16 different "combinations"(varchar). Combination is a 4-digit number, a colon and a char(A-E), . For example:
"0001:A/0002:A/0005:C/9999:E". In this case there...
I want to join two temp tables.
Here are my tables:
CREATE TABLE #Result ( Process varchar(50), SuccessCount int, FailureCount int)
CREATE TABLE #SuccessResult ( Process varchar(50), SuccessCount int)
CREATE TABLE #FailureResult ( Process varchar(50), FailureCount int)
I have some data in my ...
@rfusca What I meant is, is it actually defined as a PRIMARY KEY. Don't think it can be if it's backed by a non-unique index. As I said, you need a real PK on the table to use DBMS_REDEFINITION. You can alter the table to make it a proper PK and use the existing index online, then use DBMS_REDEFINITION to do the index change.
@jcolebrand the answer has been deleted but (a 10k user) can still be offended by rude comments on semi-visible answers. It's good that I can flag it (I didn't know I could, that's why I mentioned it here)
@ypercube To tell you the truth, many comments don't bother me, but this one kinda did, I wasn't pretending to be a moderator, and I couldn't even reply to him
I want to join two temp tables.
Here are my tables:
CREATE TABLE #Result ( Process varchar(50), SuccessCount int, FailureCount int)
CREATE TABLE #SuccessResult ( Process varchar(50), SuccessCount int)
CREATE TABLE #FailureResult ( Process varchar(50), FailureCount int)
I have some data in my ...
I wish you could vote to close an answer as a duplicate. Seriously, there are 5 identical answers there, and all have been up-voted. The question itself is marginally useful IMHO.
( add a computed constant column c add a unique index on (pk, c) -- do whatever you want with your primary key, drop it, recreate it -- drop the redundant index and column ) ;
I have no idea of the consequences on a 17GB table.
Etiquette question: Someone has answered a question pretty well (@AaronBertrand in fact), but I have one additional piece of info that could be useful to the answer. How do I approach that?
New answer or edit?
Hrmmmm....rubber duck troubleshooting now tells me I should just comment. Yay SE methodology!
@MikeFal aye. I have this idea for a regional bloc of SQL Saturday folks to help coordinate stuff like that. Encourage cross pollination of speakers and attendees as well ensure we aren't stepping onto each other's toes.
I love using the search box on friend's blogs to search for completely inappropriate terms. I hope they look through analytics and get half the laughs I do
One of the firemen finds that his parents' new microwave caused the fire. As Kevin recovers, he finds one of the firemen resembles Agamemnon, and discovers that he still has the photos from his adventure. As his parents look at a strange piece of rock in the microwave, Kevin tries to warn them off that it is a piece of concentrated evil and they should not touch it; nevertheless, both do, and suddenly explode and disappear, leaving Kevin wondering where they have gone off to.
as an aside, that wikipedia grammar is catastrophically horrible
@swasheck I saw it probably around 8 and just the boy calling to his parents and them still doing it just freaked me the F out. How do you end a movie like that?
If you add that DATEADD returns the same type as the date argument then I will accept. The "Prevent overflow if needed?" line is not needed. The roll over issue will be handled by the source of the data and the destination of the data. — Trisped3 mins ago
@swasheck thanks sir. Just seems silly to add information (that he has already learned) to the answer when it isn't part of the question, just in his head.
I have a huge table that contains both shipping address information and billing address information. I can get unique shipping and billing addresses in two separate tables with the following:
SELECT DISTINCT ShipToName, ShipToAddress1, ShipToAddress2, ShipToAddress3, ShipToCity, ShipToZipCode
FR...
@AaronBertrand i think that there's a tyranny of the urgent when it comes to asking a question. you need an answer, you don't want to look like an idiot, you worry about what others are going to think about/say to you. so you post a question and then things change. or maybe i'm just projecting. nonetheless, to not accept an answer because of my own failure to communicate is unnecessarily petty.
Don't be sorry. :-) I'm writing a blog post (maybe published tomorrow) on potential enhancements to it, was wondering what kind of bottlenecks folks come across.
How is the relevance not implied by the "Please note I am using the time data type."? Also, why did you change my question to inconstantly use row instead of record? — Trisped2 mins ago
What we have
We have 7 databases for all our internal products. Due to tight integration and lack of architecture they has a lot of circular dependencies between each other in stored procedures and functions.
We need to migrate all this jungle to TFS 2012.
Problem
After import databases into ...
i have a mysql query that lists count of title, artist
SELECT count(Key) AS Ocount, artist, title,domain, DATE_FORMAT(`FE`,'%m') AS eMonth
FROM gr
WHERE domain = 'site.com'
GROUP BY title
ORDER BY eMonth,Ocount Desc
first results are
'195', 'akon', 'beautiful', 'site.com', '01'
'20', 'ludacr...
I think it would be so bizarro to see a quote with attribution on SE that it wouldn't really matter which style you use - you'd still be blowing a lot of minds.
@BBauer42 So, my answer is the same as the third query by bluefeet, who posted more than an hour ago. Please, unaccept this and accept that so I can delete my answer. — ypercube1 min ago
@AaronBertrand in fairness, i'm fighting the battles i can. i have a local admin user on my machine and i run Chrome as that user (runas /user:.\swasheck) ... i have set the --no-sandbox flag, though. at any rate, that gives me a bit more freedom, but imgur is blocked with extreme prejudice
@rfusca "we've noted some suspicious activity on your account" ... told them what i was doing ... they "recommended" that i stop because "next time" i may end up with a disconnection of service
its about the following query.
EXPLAIN SELECT phrase, infinitiv
FROM `dict_verbs_all` `t`
INNER JOIN `dict_verbs_all_language` `verbsGerman_c`
ON (`t`.`id`=`verbsGerman_c`.`verb_id`)
INNER JOIN `dict_verbs_german` `c`
ON (`c`.`id`=`verbsGerman_c`.`verb_language_id`)
WHERE (t.phrase LIKE 'spie...
Each row in each table of my database has a RowUpdateDateTime column, which is the latest time that particular row was updated or inserted. I've also got between 1 and 7 distinct sources of data coming into each table; some have 1, some have 7.
Basically, I'm trying to loop through these tables...
In a form in webpage I want to input each of the words from a list and check if it works. As the list of words is quite huge, the task is a bit tedious manually. How to write a code for this in python?
I think that was in fahrenheit. I was in Thunder Bay, Ontario, on this day:
On 10 January 1982, the local temperature in Thunder Bay dropped to −36 °C, with a wind speed of 54 km/h for a wind chill temperature that dipped to −58 °C. As a result, it holds Ontario's record for coldest day with wind chill.
And I was the idiot who walked two blocks to the store to buy hockey cards while my family went to the grocery store. When I got back in the house, I ran my hands under cold water, and had burns/blisters for two weeks where the water first touched me, because it was so much hotter than my hands.
I had worn mittens, of course, I'm not a total idiot.
wait, I only have separate indexes on the word1, word2, lang1, lang2, I need to put on the joint indexes. I will continue experimenting tomorrow as my host only allows 20 minutes of MySQL time a day. — Sandor3 mins ago
For your initial situation, it seems you tried something like this:
CREATE DATABASE YAFnet ON (FILENAME = N'C:\sql_data\YAFnet.mdf')
FOR ATTACH;
However, this method requires both an mdf file and an ldf file. Otherwise you get an error message similar to:
Msg 5120, Level 16, State 101, Lin...
I have a view in Sql Server 2008 that when performing just a:
SELECT * FROM [Table]
Will return roughly 40000 rows by 130 columns. Here are 6 runs with client statistics on (roughly 7 seconds average):
Let's just assume those times are fine, the problem comes when a filter is applied. Here ...
What are the differences between CREATE INDEX and CREATE STATISTICS and when should I use each?
I want to join two temp tables.
Here are my tables:
CREATE TABLE #Result ( Process varchar(50), SuccessCount int, FailureCount int)
CREATE TABLE #SuccessResult ( Process varchar(50), SuccessCount int)
CREATE TABLE #FailureResult ( Process varchar(50), FailureCount int)
I have some data in my ...
I think your schema ought to look something like this:
http://homepages.tcp.co.uk/~m-wigley/gc_wp_ded.html
What we have
We have 7 databases for all our internal products. Due to tight integration and lack of architecture they has a lot of circular dependencies between each other in stored procedures and functions.
We need to migrate all this jungle to TFS 2012.
Problem
After import databases into ...
i have a mysql query that lists count of title, artist
SELECT count(Key) AS Ocount, artist, title,domain, DATE_FORMAT(`FE`,'%m') AS eMonth
FROM gr
WHERE domain = 'site.com'
GROUP BY title
ORDER BY eMonth,Ocount Desc
first results are
'195', 'akon', 'beautiful', 'site.com', '01'
'20', 'ludacr...
its about the following query.
EXPLAIN SELECT phrase, infinitiv
FROM `dict_verbs_all` `t`
INNER JOIN `dict_verbs_all_language` `verbsGerman_c`
ON (`t`.`id`=`verbsGerman_c`.`verb_id`)
INNER JOIN `dict_verbs_german` `c`
ON (`c`.`id`=`verbsGerman_c`.`verb_language_id`)
WHERE (t.phrase LIKE 'spie...
Each row in each table of my database has a RowUpdateDateTime column, which is the latest time that particular row was updated or inserted. I've also got between 1 and 7 distinct sources of data coming into each table; some have 1, some have 7.
Basically, I'm trying to loop through these tables...
In a form in webpage I want to input each of the words from a list and check if it works. As the list of words is quite huge, the task is a bit tedious manually. How to write a code for this in python?
