Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,836 reads
Vivek's SQL Notes
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...
2009-12-22
2,176 reads
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,252 reads
Sql Server - How to write a Stored procedure in Sql server
Stored Procedure:-Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are...
2009-12-05
1,499 reads
Sql Server - Union and Union All
Union and Union All, both are used to select data from one or more than one tables but still they...
2009-11-17
4,486 reads
IDENTITY Property in SQL Server
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,861 reads
Technology with Vivek Johari: How to make database offline or online
Technology with Vivek Johari: How to make database offline or online
2009-10-19
667 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Parameter sniffing issue with different minutes as opposed to using midnight
Hej, I'm not facing this issue but as I was working another parameter sniffing...
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...