sql-server
Do unused indexes cause performance issues with sql server? And should I remove them?
I\'ve spent some time researching this and simply can\'t find a definitive answer. Here is the query I am using to look for indexes not used:[详细]
2023-04-01 03:52 分类:问答SQL query in Excel takes far longer when using ? to get a cell value than with value specified in query
I\'ve written an Excel query of a SQL Server database to display results from a complex view.The view uses a join on several tables of less than 10K records, returns about 620 rows and takes 1-4 secon[详细]
2023-04-01 03:37 分类:问答how to use case statement in group by
I have following case statements in my SELECT clause, also I have a group by clause... So, Is it okay to specify UF.CO开发者_StackOverflow中文版NT_PID & UF.M_STATUS_CDin my[详细]
2023-04-01 03:10 分类:问答Query returns different results
I have 2 queries( i belive they must return same amount of rows:) ) : 1. SELECT NAME FROM myDataBase.myTable[详细]
2023-04-01 03:08 分类:问答SQL Query help - Condition applies only for the Newest Record
Below is the simplified version of the Table. My query is select all the patientIds where the last X Test Result is over10. Result should be only patientID 1 and 3.[详细]
2023-04-01 02:40 分类:问答Get year and month from SQL
I want to 开发者_开发百科know how can I get the year and month into my database. For example, suppose it’s August, 2011. The output that I need is like this: CAB 11 08 001 (CAB + YEAR + MONTH + CURRE[详细]
2023-04-01 02:23 分类:问答Migrating SSAS Changes
Assume you have 2 SSAS databases, DB1 and DB2, that are identical. Now they开发者_运维技巧 branch off. Changes A and B are made to DB1 and changes C and D are made to DB2.[详细]
2023-04-01 02:11 分类:问答Performance when Ordering By Computed Column
I have to sort a fairly large set of data based on a computed column. Here is part of the query that does the sorting[详细]
2023-04-01 01:48 分类:问答problematic sql server query
I have the following query which is running slow: WITH AcdTran AS (select SequenceNo, ReqID, PolNumber, transaction_id,[详细]
2023-04-01 01:46 分类:问答SQL Server Have a select query as part of one select columns
Hey Im just wondering if the following is possible select id, name, (select name from secondTable where companyId = tableOne.id) as concatenatedString..[详细]
2023-04-01 01:34 分类:问答