Viewing 15 posts - 1 through 15 (of 88 total)
daveburch235 (12/2/2016)
December 2, 2016 at 9:26 pm
I also faced this issue, and following blog post helped a bit in understanding what negative SPIDS are: http://www.mytechmantra.com/LearnSQLServer/Kill-Negative-SPID-in-SQL-Server/[/url]
June 20, 2016 at 11:24 pm
I also had this issue today with my DEV DB server, and database was showing in Recovery Pending State.
On running the mentioned statement in one of previous responses, the database...
February 13, 2016 at 11:31 pm
You can test the R integration with SQL Server 2016 now, as its has been released with the beta/preview version i.e. CTP 3.
October 29, 2015 at 5:28 am
"R" was not part of CTP2 release of SQL Server 2016.
It might be coming with the CTP3 release or with the RTM, and followed by the MSDN/Technet articles.
June 16, 2015 at 5:02 am
"R" was not part of CTP2 release of SQL Server 2016.
It might be coming with the CTP3 release or with the RTM, and followed by the MSDN/Technet articles.
June 16, 2015 at 5:00 am
Check what's New in SQL Server 2016 Database Engine (MSDN BoL): https://msdn.microsoft.com/en-us/library/bb510411(v=sql.130).aspx
June 16, 2015 at 4:54 am
"R" support is not in CTP2, it will come in CTP3 release of SQL Server 2016
June 16, 2015 at 4:49 am
Yes Jeff,
The currently released version of SQL Server 2016 is CPT2, where you can only export SQL table rows in JSON string format.
I've put this in a blog post http://sqlwithmanoj.com/tag/json-sql/[/url].
With...
June 4, 2015 at 9:04 am
Well with SQL Server 2016 you can export SQL table rows into JSON string format. JSON in SQL will just work like XML with similar semantics.
June 4, 2015 at 12:26 am
Well with SQL Server 2016 you can import a JSON string into a SQL table. JSON in SQL will just work like XML with similar semantics.
This feature is coming in...
June 4, 2015 at 12:19 am
Well with SQL Server 2016 you can export SQL table rows into JSON string format. JSON in SQL will just work like XML with similar semantics.
June 4, 2015 at 12:17 am
What error you are getting?
I think you have not specified the database and schema name, can you try this:
set @query ='BULK INSERT dbname.dbo.'+ @Tablename + ' FROM "'+ @Filepath+@Filename+'" WITH...
May 13, 2015 at 1:10 pm
Forget Job success/failure, did you try to send a test email after configuring db mail? -- please ignore this, I didn't read the last line in your question.
If not then...
May 13, 2015 at 12:56 pm
Viewing 15 posts - 1 through 15 (of 88 total)