2021-01-01
590 reads
humor
2020-12-25
737 reads
2020-12-22
174 reads
2020-11-26
562 reads
2020-10-30
760 reads
2020-05-04
101 reads
2020-05-04
660 reads
2020-04-01
777 reads
Cursors Without Performance Penalties
Imagine how coding might take place if cursors were as efficient as complex SELECT statements.
2020-04-01
337 reads
SQL v.Next Gets Native Python in SQL Server
The next version of SQL Server is in early preview and there is a new feature that is going to be very useful for large enterprises that want to run Big Data Clusters and perform additional data science tasks. Instead of embedding Python code in a string and submitting it to the Launchpad engine, we […]
2020-04-01
4,131 reads
Blogs
What is a model database?
By gbargsley
Do you ever take a look at SSMS in the System Databases section? People...
Daily Coping 26 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Rowcount estimates when there are no Statistics
When you don't have statistics, what does SQL use to calculate the estimated number...
Forums
How to create a gantt chart for event rooms during a day
Hi all, This will be my first ever post in a forum like this....
[ODBC Error]
When backup job runs we are receiving the below error and database connection closes....
Error: The size necessary to buffer the XML content exceeds the buffer quota
Hi Guys, I have a report named Master and a report named Child, Child...
Ask SSC