Network profile

Shaneis

Reputation

1,773

1.8k
1.6k
1.4k

2018
2019
2020
2021

Top tag

sql-server

Next privilege

2,000 Rep.

Edit questions and answers

Badges

2

12

20

Newest

Populist

Next badge

3/5

Impact

7 posts edited

10 helpful flags

505 votes cast

Answers (17)

Votes Activity Newest

60	Test if a string is a palindrome using T-SQL
29	What's the difference between WITH CTE & WITH CTE (<column_names>)?
15	Using WITH and IF in the same query
6	How to replace column if not null in select statement?
5	Create a “INTO” table with primary key

View more →

Reputation (1,773)

+40	What's the difference between WITH CTE & WITH CTE (<column_names>)?
+10	How to replace column if not null in select statement?
+15	Separate letters from digits in alphanumeric string
+10	Powershell dbatools combining result of multiple Get-dbaxxx commands to generate a report

View more →

Questions (3)

Votes Activity Newest

7	Is there a way to see how SQL Server 2012 defines new identities?
2	Why is Include Actual Execution Plan not included in @@Rowcount when it produces a row count?
1	Include scripts for Indexes on Alter Views

Tags (25)

130 sql-server × 15	29 cte
82 sql-server-2012 × 8	5 identity × 2
75 t-sql × 4	5 auto-increment
66 functions × 2	5 regular-expression
30 sql-server-2014 × 2	5 stored-procedures

View more →

Bookmarks (3)

Votes Activity Newest Views Added

28	SQL Server 2014: any explanation for inconsistent self join cardinality estimate?
18	Multi-statement TVF vs Inline TVF Performance
5	Is there a way in SQL Server to make a table only able to insert by trigger?

Accounts (15)

	Database Administrators	1,773 rep	2 gold badges12 silver badges20 bronze badges
	Stack Overflow	1,010 rep	1 gold badge11 silver badges20 bronze badges
	Mathematics	101 rep	3 bronze badges
	Data Science	101 rep	2 bronze badges
	Philosophy	101 rep	3 bronze badges

Badges (24)

Recent Class Name

Populist	Fanatic
Yearling × 6	Civic Duty
Good Answer × 2	Talkative
Enlightened × 2	Enthusiast
Nice Answer × 3	Commentator

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (505)

all time			by type
484	up		146	question
21	down		359	answer

Database Administrators Stack Exchange works best with JavaScript enabled