No announcements
-
0 VotesEliminating brackets in a search
This is strange. Does anyone have an idea on how to remove strings from a search where the string contains a bracket? In the case below, search needs to show only the last two ...Answered | 2 Replies | 303 Views | Created by Crakdkorn - Sunday, January 26, 2020 8:28 PM | Last reply by Dedmon Dai - Monday, January 27, 2020 8:21 AM
-
0 Votes
How to get value After "A"
My database Cust Id Start Like "A1.....A10....A100...." How to I get max value and increment value EX.. Max id = ...Unanswered | 4 Replies | 725 Views | Created by K.VelRaj - Sunday, December 22, 2019 11:14 AM | Last reply by George Kosmidis - Monday, December 23, 2019 9:00 AM -
0 Votes
How to implement Search in SQL Server for Matrimonial Website
I have a database built on SQL Server 2017 for a matrimonial website. It has few hundreds of tables where user profile properties, partner preferences etc. are ...Unanswered | 0 Replies | 505 Views | Created by Bhanu Prakash T - Wednesday, December 18, 2019 9:17 AM -
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 | 1023 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 | 846 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 | 1530 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 | 1311 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 | 1268 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 | 1669 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 | 1456 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 | 1829 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 | 1988 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 | 20393 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 | 1640 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 | 1838 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 | 2139 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 | 1768 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 | 1924 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 | 2142 Views | Created by wenzzzel - Saturday, May 18, 2019 3:10 PM | Last reply by wenzzzel - Saturday, May 18, 2019 8:34 PM - Items 1 to 20 of 1364 Next ›
No announcements
