Answer - Question of the Week - 28/12/2013 - Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
593 reads
Vivek Johari
- Interests: SQL, database, Oracle, Big Data, Azure
- Website: https://www.techmixing.com
While loop in SQL server
In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....
2014-01-01
22,825 reads
Happy New Year 2014
HAPPY NEWYEAR2014
Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my...
2013-12-31
1,017 reads
Deleting Duplicate rows using CTE
Many times we caught in a situation where we have a table where there is no primary or unique column...
2013-12-29
59,382 reads
Answer -Question of the Week - 25/12/2013- Question 1
Question:- Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it...
2013-12-28
758 reads
Question of the Week - 28/12/2013 - Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...
2013-12-28
523 reads
Question of the Week -25/12/2013- Question1
Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it contains...
2013-12-25
467 reads
Ranking Functions in SQL Server
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition....
2013-12-25
9,946 reads
Case Statement/ Expression in SQL Server
Case Statement/ Expression in SQL server
Sometimes we need to get one result output from multiple possible outcomes based on the...
2013-11-25
1,780 reads
Stuff VS Replace function in SQL Server
Stuff function: - This function is used to replace string from the given start position, passed as 2nd argument with string...
2013-11-25
34,466 reads
Blogs
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
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...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
SSIS Package is reporting successful however is short 80-100k records
Good morning all, I have been running into a very random weird issue that...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers