Stored Procedure to Sequentially Run SQL Agent Jobs
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
2,672 reads
Professional Association of SQL Server (PASS)
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...
2010-01-31
2,033 reads
Interview Questions on Sql Server -Part 3
1. What are the Sql Joins?Sql Joins are the way to get data from many tables based on some logical...
2010-01-31
1,952 reads
Reading in 2009
I saw a blog post from my friend Paul Randal recently in which he recounted the books he’d read in...
2010-01-31
1,770 reads
Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All?
1) Union is used to select distinct data from the...
2010-01-31
2,008 reads
Interview Questions on sql server -Part-1
1. What is the Normalization?Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table...
2010-01-31
2,194 reads
Group by.....Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns.
The syntax...
2010-01-31
2,570 reads
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there...
2010-01-31
11,980 reads
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a...
2010-01-31
4,056 reads
Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It...
2010-01-31
1,735 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers