No announcements
-
0 Votes
need to have ordered results in one shot query instead of 3 queries
Hello, I have the following query where i do 3 searches and then make union between them so that the results are ordered, is there a way i can do this in one shot without losing the ...Unanswered | 3 Replies | 278 Views | Created by Mahaghsql - Wednesday, November 27, 2019 10:30 AM | Last reply by Soumen Barua - Wednesday, November 27, 2019 6:14 PM -
0 Votes
Full Text Search in Azure - Population Issue
I'm running a Azure SQL Server (Single Instance, General Purpose, Serverless, Gen5, 4 vCores, auto-pause disabled). I've setup a Full Text index on a table but the Population process ...Unanswered | 1 Replies | 323 Views | Created by oz909 - Thursday, November 14, 2019 3:19 AM | Last reply by oz909 - Friday, November 15, 2019 2:02 AM -
0 Votes
What is OSQL?
what is osql ? how can use it? what is commands?!Proposed | 2 Replies | 820 Views | Created by AhhI1075 - Saturday, October 5, 2019 7:30 PM | Last reply by Olaf Helper - Monday, October 7, 2019 7:01 AM -
0 Votes
Restore content database sharepoint
Hi There, I have a problem where I need to restore one of content database production sharepoint. Users deleted one of the file from Sharepoint last Thursday ...Unanswered | 2 Replies | 604 Views | Created by ken Myer - Monday, October 7, 2019 1:25 AM | Last reply by ken Myer - Monday, October 7, 2019 3:16 AM -
0 Votes
XML Attribute Values in XML Columns Not Indexed for Fulltext Search
Hello, I'm using SQL Server 2016 Developer (13.0.5101.9). I've created Fulltext Catalog for Table with XML Column. According to the documentation Attribute values ...Unanswered | 0 Replies | 719 Views | Created by Boris Lehečka - Wednesday, September 4, 2019 8:48 PM -
0 Votes
Full text index rebuild
We've developed an ASP.NET MVC application serving hundreds of concurrent users on a sql server 2016 database (running in compatibility mode 2008). One of our ...Unanswered | 2 Replies | 1002 Views | Created by rfazley - Wednesday, September 4, 2019 1:11 PM | Last reply by Olaf Helper - Wednesday, September 4, 2019 1:51 PM -
0 Votes
Optimization of MAX function with limited parameter
I have the following query SELECT MAX(someF.number) FROM someTable AS someT CROSS APPLY( SELECT someFunction(someT.column1, ... -
0 Votes
Performance of query on indexed Boolean/Bit column vs Datetime column
GETDATE() ? . · * ´ ¨ ) .· ` T C H ( . . · *Unanswered | 1 Replies | 889 Views | Created by tcCoder - Thursday, August 22, 2019 8:17 PM | Last reply by Rafael S. Melo - Thursday, August 22, 2019 8:54 PM -
1 Votes
Two Select Statements: Select referring previous select query
Hi Friends, i have two working queries in that I st query fetch all the details from Fromdate to ToDate II Query calculate efficiency for every person on all dates, that date and ...Unanswered | 1 Replies | 1250 Views | Created by Shankar T - Monday, July 15, 2019 9:00 AM | Last reply by José Diz - Friday, August 9, 2019 10:20 PM -
1 Votes
SSIS Error - SFTP in C#
Hi, I found this script using System; using System.Data; using System.Text; using System.Linq; using ...Answered | 2 Replies | 1010 Views | Created by Vo Hoang Ngoi - Monday, July 29, 2019 12:05 PM | Last reply by Elizabeth Swain - Monday, July 29, 2019 2:50 PM -
3 Votes
Full Text problem indexing .eml files in SQL Server 2008
Hi, I have a database that will store a table consisting of email files in a VARBINARY(MAX) data type. In SQL Server 2005 (9.0.4053) I have had no problems. However, in ...Unanswered | 10 Replies | 19773 Views | Created by RJL61 - Wednesday, March 3, 2010 11:44 PM | Last reply by Meiss-OD - Monday, July 29, 2019 7:19 AM -
2 Votes
Getting SQL version info from list of server names
I am wondering if there is a powershell script I can run against a .txt file with server names in it that will return the version of SQL on that list of servers. Any help is ...Unanswered | 2 Replies | 1043 Views | Created by Charlie4872 - Friday, July 5, 2019 2:33 PM | Last reply by Charlie4872 - Friday, July 5, 2019 4:26 PM -
0 Votes
Update SQL statement failing when using != or In
Contactname is varchar(1000) UPDATE customers SET ContactName='Statecode !='MA'' WHERE CustomerID=1; Update SQL statement ...Answered | 2 Replies | 1122 Views | Created by Michael3188 - Wednesday, June 19, 2019 4:17 PM | Last reply by Michael3188 - Wednesday, June 19, 2019 9:03 PM -
0 Votes
Full-Text Index have limit number of rows
In below link, there are "There are other failures that can impact the indexing process itself and prevent the population from completing:" phrase. In that ...Unanswered | 1 Replies | 1499 Views | Created by Adele Vance - Wednesday, June 5, 2019 9:19 AM | Last reply by Comeau P - Thursday, June 6, 2019 7:57 PM -
0 Votes
Does registry path to get instance of sql server constant for all versions? Path : @'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL' ?
I am thinking to use following path to check instance for all sql server version (From SQL server 2005 - SQL Server 2017) Path : @'SOFTWARE\Microsoft\Microsoft SQL Server\Instance ...Unanswered | 2 Replies | 1115 Views | Created by AngelVpd - Friday, May 24, 2019 8:58 AM | Last reply by Hari VS_Kid - Tuesday, June 4, 2019 8:40 AM -
0 Votes
Fast searching via sqlserver stored procuedure
Hi friends, Following sqlserver 2012 stored procedure I am calling from vb.net which is used for product searching by code and by name ...Answered | 3 Replies | 1228 Views | Created by malikasad - Thursday, May 30, 2019 10:32 AM | Last reply by scott_morris-ga - Thursday, May 30, 2019 2:45 PM -
0 Votes
How can I have a clustered key index on an id field that is'nt unique?
Hi! I'm kind of new to sql server so this probably sounds like a stupid question to you who been in the game for a while. I understand that if you make one ...Unanswered | 3 Replies | 1538 Views | Created by wenzzzel - Saturday, May 18, 2019 3:10 PM | Last reply by wenzzzel - Saturday, May 18, 2019 8:34 PM -
2 Votes
SSRS Matrix Sort Order
Hi, Could you please help me to display the data as per the SQL Query Result in a SSRS Matrix Report. I have tried deleting the sort order from the group ...Unanswered | 9 Replies | 1749 Views | Created by Mohammad Afshaan Shaikh - Thursday, April 25, 2019 6:36 AM | Last reply by Mohammad Afshaan Shaikh - Tuesday, April 30, 2019 8:50 AM -
0 Votes
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0
Hi All .need help .. When I am running this from cmd on my sql 2008 database server: sqlcmd -U sa -S mymachinen_name\MSSQLSERVER , ...Answered | 3 Replies | 13308 Views | Created by rickepm_ms - Sunday, February 22, 2015 3:36 PM | Last reply by mojie379120 - Tuesday, April 23, 2019 5:55 AM -
0 Votes
SQL Sever Query
Hi, i am trying to retrive required data from the below ...Unanswered | 3 Replies | 2419 Views | Created by Mohammad Afshaan Shaikh - Wednesday, April 17, 2019 10:13 AM | Last reply by Dedmon Dai - Monday, April 22, 2019 1:33 AM - Items 1 to 20 of 1361 Next ›
No announcements