|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Configure Polybase | |
I want to enable my SQL Server instance to use the Polybase connection to Hadoop. What option needs to be configured? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Formatting the date If I have this code: >>> import time >>> myString = '02/08/2019' >>> myDatetime = time.strptime(myString,"format_string") What is the correct way to enter the format_string for a date in August using numbers? Answer: %d/%m/%Y Explanation: The strptime() method from the time module needs to know the format of the string to properly place the character. The day format is #d. Month is %m. Year is %Y. Ref:
|
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Cannot generate sspi context (sql server) - Hi, Can't login to this SQL Server using Management Studio remotely - but can when RDPed to the server itself? |
SQL Server 2017 - Development |
Azcopy usinf sql sp - Hello Experts, I am working on SP that sends my csv file from on prem machine to Azure blob container. I am using lastest Azcopy v10. DECLARE @Program varchar(200) = '"C:\AzCopy.exe"' DECLARE @Source varchar(max) = 'E:\Backup\abc.txt' DECLARE @Destination varchar(max) = 'https://myaccount.blob.core.windows.net/' DECLARE @DestKey varchar(max) = 'secret key' DECLARE @Options varchar(max) = '/S /XO /XN /Y […] |
SQL Server 2016 - Administration |
SQL Server Agent stops unexpectedly - Buffer Overflow - Our SQL Agent has been randomly crashing for the last month and a half. The last time it crashed we had procmon running on the server monitoring SQLAGENT.EXE and prior to it shutting down there was a bunch of Buffer Overflow events, see screen shot attached. There was a probably a 1000 of these all […] |
Performance related question - This (performance) is the area time to time I struggle with. Couple of days ago, we had an issue where all of a sudden, an application started running slow. I was told to look into it from a SQL Server side and I couldn't find anything (atleast from what I know) because all the available […] |
Basic Avaialbility without active Directory - Hi , I am trying to configure Basic Allwayson in SQL 2016 Standard edition using the below ebsite https://www.sqlpassion.at/archive/2016/01/11/how-to-create-a-sql-server-availability-group-without-an-active-directory-domain/ I did below things. Firewalls off in both nodes SQL-1 & Sql-2 I created DNS Suffix in both servers as Testing.com Remote registry and Remote administration is enabled in both nodes. i enabled Failover clustering In powershell […] |
issue with sql connectivity - Hi Experts, This is more of a generic question on sql connectivity. Under what circumstances, users will not be able to connect to sql server instance. The services are up and running though. Firewall is open. TELNET is working and still users are complaining that there app's are unable to connect to sql server. What […] |
SQL Server 2016 - Development and T-SQL |
SQL Lite Data Types VS T-SQL Data Types - I am having trouble running this SQL Lite on my T-SQL. I changed the NUMBER to NUMERIC n Decimal in SQL Server. Still i am getting this error. What would be the equivalent data type in SQL Server. All of the other SQL Lite code are running on my SQL Server Express, except this: DROP […] |
SQL Server 2012 - T-SQL |
Trying to insert from table 1 with missing index to table 2 with index - Table 1 is missing an index that was supposed to be in place when the table was created that is set to unique. The table has an identity column. I have created the table 2 new with the index in place and is empty. (Table 1 and 2 are the same structure except table 1 […] |
Insert into Select with Conditions - Hello, I think my requirement is fairly straight forward, but cant seem to get the syntax right or find a solution. Im, trying to do a Insert into Select , that will allow duplicates only if a field value in a row is null. hope that makes sense. - thanks Greg |
SQL Server 2008 - General |
Relations of system tables, Sys.dm_exec_connections?sys.dm_exec_sessions and ... - What are the relations among Sys.dm_exec_connections? sys.dm_exec_sessions and sys.dm_exec_requests and what are the relations among Sys.dm_exec_connections? sys.dm_exec_sessions ?sys.dm_exec_requests and sys.sysprocesses ? I check it on MSDN,but not clear the explanation yet, could you please help me to make a detailed explanation ? thanks |
SQL Server 2008 Performance Tuning |
Huge speed difference with clause "If exists" - I have a fairly simple stored procedure that checks to see if a value is present in a view. It's horribly slow when it's executed one way, and reasonably quick another way. i don't understand why there is such a difference. Here they are: Slow: if exists (select 1 From BotCBO.vwClovekStrings_PrZk Where ClovekString = '[gmelin]') […] |
Data Transformation Services (DTS) |
dtexec delay validation true - I have a SSIS package that loads a flat file. It runs fine on my laptop but on my virtual machine I have to set DelayValidation to true otherwise it looks like it loads the data then removes it from the final table. On the virtual machine if I run the package from the Visual […] |
Integration Services |
Package complete but a task is still running, not getting all of the data - Ok, so using SSIS (Visual Studio 2015) and running a single package from the IDE. Now there is no event logging etc. The message come up at the bottom of the screen to say its completed. Everything looks complete. I open up the data flow task and strange things appear. As in the picture below […] |
Possible double hop issue - SSIS Package / SSIS Catalogue - Wanted to check if anyone else was able to resolve this and how they did it. In a nutshell we have a package stored in SSIS catalogue on Server – S1 which reads files from Server – S2 ( NAS share) and then the package stored in SSIS catalogue is executed via a C# app […] |
SQLServerCentral.com Website Issues |
Search box returns error when clicked - |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |