All Questions
0
votes
0answers
10 views
Column does not exist in UNION ALL query
I am doing some code for my badminton club.
Tables
CREATE TABLE School (
Name text PRIMARY KEY
);
CREATE TABLE Tournament (
Number integer PRIMARY KEY
);
CREATE TABLE Player (
Name ...
0
votes
1answer
12 views
How to query results where a column with 2 classifications has same value in another column in the same table?
I have a table like this:
Column A Column B
-------------------------
Agent A [email protected]
Agent B [email protected]
Agent A [email protected]
Agent B [email protected]
Agent C efg@gmail....
0
votes
0answers
18 views
sp_BlitzIndex v 4.5 (2016-11-15) failing with collation error
Posting this in case anyone else runs into this issue... (fix below)
After updating to SQL 2016 SP1, I also updated to the latest version of the sp_Blitz procs. Unfortunately, sp_BlitzIndex now blows ...
0
votes
1answer
12 views
Importing Data in Parallel in SQL Server
I have more than 100 files to import into the sql server and most of them are of 500 MB. I want to leverage the the parallel import utility of SQL server and have read a number of webpages, like the ...
0
votes
0answers
20 views
Can be someone watching me what am I doing or the profiler trace is default
We do have CRM Dynamics 2015 (on-premise) and we do have production and Development SQL DB. Production is on Server A and Development is on Server B.
Anytime I login and run following query it give ...
1
vote
0answers
16 views
Alternative to removing ONLY_FULL_GROUP_BY
After upgrading from MySQL 5.5 to MySQL 5.7 I'm getting an error with some of my queries:
ERROR 1055 (42000):
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
0
votes
0answers
17 views
How can I migrate from a standalone SQL Server to a failover cluster with the same IP?
I want to move existing databases from a standalone SQL Server instance to a failover cluster but need to do it in a way that connections strings and such which reference the existing server by host ...
0
votes
0answers
18 views
Resource semaphore Query Compile and Maxdop Setting SQL 2014
We have migrated SQL standard edition from 2008R2 to SQL 2014. After the migration we are seeing huge amount of blocking and overall SQL instance is very slow.
Major wait stats we are seeing is ...
0
votes
0answers
22 views
In a school database, do I need to have repeating data when a student can also be a teacher?
I've seen lots of ERDs of schools, teachers, and all the junction/associative tables. They always have three tables:
Teachers
Students
Associative table betweeen them, maybe subjects of something ...
0
votes
0answers
10 views
MySQL 5.6 Alter table to Add Column If It Does Not Exist Has Syntax Error
I'm writing a mediawiki plugin where I need to add a column to an existing table. Googling around here is the query I came up with based on these questions.
http://stackoverflow.com/questions/...
2
votes
0answers
24 views
Normalization vs denormalization for these kind of data?
I'm using Firebase realtime database (NoSQL), And trying to figure out the best database design for my data.
My data is primarily about discounts, each affiliator introduces a number of discount ...
0
votes
0answers
15 views
When you make a trivial change to a view, do permissions get reset?
Just wondering - I made a trivial change to a view.
No additional tables were added, although I guess the logic was changed a bit and a subquery was added --- but again, no additional base tables.
...
0
votes
0answers
5 views
SSAS Deployment Wizard - Issue with multiple connection strings
I've observed an issue with the SSAS Deployment Wizard.
I have two environments DEV and PROD.
A few weeks ago when I deployed anything on PROD I had one connection string only there to PROD (similar ...
0
votes
1answer
5 views
use different odbc conector to connect mysql server
We found out Mysql odbc connector is released under gplv2 license. We have a commercial application (in c#) that connects to mysql (using Mysql.data) so we are supposed not to use mysql odbc connector ...
0
votes
0answers
41 views
SQL Server 2012 Query Perfomance
I have an issue with sql server not performing good when compared to old server.
The problem is SQL Server is not using all the columns in the index making it fetch over 45 million rows as opposed to ...
