Viewing 15 posts - 8,851 through 8,865 (of 59,078 total)
I have a question for all you folks claiming that every table must have a natural key. What would you use for a natural key for either an...
August 12, 2019 at 3:18 pm
I have a question for all you folks claiming that every table must have a natural key. What would you use for a natural key for either an...
August 12, 2019 at 3:06 pm
I hate these types of things even on YouTube even if it's a worthwhile lesson. The computer generated voice is rather monotonous and makes a lot of mistakes in pronunciation,...
August 12, 2019 at 12:40 am
You say it was a BIG prod release... how much of it involved expansion of data and the addition of a lot of indexes, especially clustered indexes and large covering...
August 11, 2019 at 4:21 pm
Jeff,
That is true, but since the OP explicitly asked about bridge tables in data warehouses, I figured I'd give them the best resources I know of instead of telling...
August 11, 2019 at 3:47 pm
I have a question for all you folks claiming that every table must have a natural key. What would you use for a natural key for either an Employee table...
August 11, 2019 at 2:33 pm
Otherwise, JSON can provide an adequate data store.
so if we want relational we go with CSV right?
BWAAAA-HAAAA-HAAAA!!!! I blew coffee out of my nose on that one! +1 Billion!!!...
August 11, 2019 at 2:29 pm
I pass the name of the server and database to the stored procedure and then use the exec command to execute this as a string then in Visual Studio...
August 11, 2019 at 2:25 pm
For me it’s a default task to attempt Developing SQL Databases Exam but now I strongly make my mind to attempt it, I want to pass my exam in...
August 11, 2019 at 4:17 am
Hi,
i need to automate the index rebuild on specified tables.
1)identify the table which is having more than 30 % ( i need top tables)
2)those tables needs to index rebulid...
August 11, 2019 at 4:12 am
Good links, Chris. Just to be sure, though, you don't have to have a data warehouse to use "Bridge Tables".
August 9, 2019 at 7:05 pm
Why did you add the "HAVING"? You need to see it all to actually make a determination.
August 9, 2019 at 6:29 pm
Due to some limitations we may have to monitor all of our sql servers with two different monitoring tools. Would that we bad idea and what other issues i...
August 9, 2019 at 6:27 pm
So Jeff, do you have an opinion on Datatime addition ?
Heh... ya think? 😉
August 9, 2019 at 6:18 pm
If you would post your data in a readily consumable format, I'm sure someone would jump on this problem and provide a correct solution in about two heart beats. Please...
August 9, 2019 at 3:42 pm
Viewing 15 posts - 8,851 through 8,865 (of 59,078 total)