No announcements
-
0 VotesWhat is OSQL?
what is osql ? how can use it? what is commands?!Proposed | 2 Replies | 126 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 | 93 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 | 258 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 | 290 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 | 383 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 | 654 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 | 519 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 | 19283 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 | 625 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 | 710 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 | 775 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 | 753 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 | 651 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 | 931 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 | 974 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 | 12587 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 | 1842 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 -
0 Votes
No results of SQL Full-Text Search
Welcome, I have a problem with results of searching by using SQL Full-Text Search. The FTS engine not finding the phrase ... -
1 Votes
Best and simple way to know,who created/dropped/altered the database?
Hello What is simple and easiest way to know,who created/dropped/altered the database? Thanks in advance.Answered | 3 Replies | 1510 Views | Created by Irfankhan1995 - Sunday, March 17, 2019 4:42 AM | Last reply by scott_morris-ga - Sunday, March 17, 2019 12:34 PM - Items 1 to 20 of 1359 Next ›
No announcements
