Profile Activity

Racer SQL

Meta user

Network profile

Reputation

3,303

3.3k
1.9k
467

2016
2017
2018
2019

Next tag badge

sql-server

44/100 score

21/20 answers

Badges

Newest

Next badge

95/100

Impact

18 posts edited

44 helpful flags

513 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

167 Questions

Views Newest Activity Votes

votes

answers

views

How can I only UPDATE if the user was created?

sql-server-2012 sql-server-2008

Sep 18 at 13:56 Peter B 234

votes

answers

views

Is there a better way to DENY SYS schema and INFORMATION-SCHEMA to DBO user?

sql-server-2008-r2

Sep 3 at 15:02 Racer SQL 3,303

votes

answers

views

How can I track if a trace is executing?

sql-server sql-server-2008-r2 trace

Aug 28 at 13:38 Tom V 14.2k

votes

answer

545

views

How to trace a query on Firebird?

query audit firebird trace

Aug 9 '18 at 8:53 Mark Rotteveel 817

votes

answer

views

Best idea to deal with historic data ( Partitioning? )

sql-server-2008-r2

Aug 7 '18 at 15:51 Yaroslav 2,077

votes

answers

views

Firebird ODBC Setup - Linked server from SQL Server 2008 to FireBird Database

sql-server-2008-r2

Jul 30 '18 at 19:26 Racer SQL 3,303

votes

answers

views

Different databases should have same scructure/values on tables

sql-server sql-server-2008-r2

Jul 10 '18 at 18:50 Max Vernon 54.5k

votes

answer

408

views

Problem with charset on SQL*PLUS

oracle

May 24 '18 at 13:15 Racer SQL 3,303

votes

answer

views

Help with a logic inside WHERE or ORDER BY

sql-server-2008-r2

May 18 '18 at 13:14 Jonathan Fite 4,586

votes

answers

views

Stored procedure runs forever, but inner query runs fine

sql-server-2008 performance t-sql query-performance stored-procedures

Jan 15 '18 at 18:52 Aaron Bertrand♦ 158k

votes

answers

159

views

How to list LOGIN + ROLE in SQL Server 2008?

sql-server security scripting logins role

Jan 15 '18 at 14:18 Aaron Bertrand♦ 158k

votes

answer

views

implement this query inside a cursor

sql-server-2008-r2

Jan 9 '18 at 19:10 Aaron Bertrand♦ 158k

votes

answers

270

views

Returning only duplicated data

sql-server sql-server-2008

Dec 27 '17 at 14:32 ypercubeᵀᴹ 79.9k

votes

answer

views

Why is my cursor not stopping in the last table?

sql-server sql-server-2008

Dec 1 '17 at 13:24 Tom V 14.2k

votes

answer

views

Concatenate with NULL values ( Should not replace NULL )

sql-server sql-server-2008-r2 null string-manipulation

Sep 25 '17 at 23:16 Paul White♦ 57.6k

votes

answers

160

views

How to get rid of these Key Lookups?

sql-server index t-sql sql-server-2014

May 24 '17 at 15:00 Racer SQL 3,303

votes

answers

views

How to make this query, to INNER JOIN with the schema?

sql-server-2008-r2

May 18 '17 at 16:14 Racer SQL 3,303

votes

answer

537

views

Alter table Alter column Performance

sql-server-2008

May 18 '17 at 15:07 Community♦ 1

votes

answers

108

views

simple RECOVERY mode, but with not static data

sql-server-2008 sql-server-2012

Apr 27 '17 at 6:08 hot2use 8,938

votes

answer

views

Hallengreen's Index maintenance query not using all indexes

sql-server-2008

Apr 24 '17 at 15:49 George K 1,192

votes

answer

views

Open Management Studio with configured connections

sql-server ssms

Apr 19 '17 at 12:17 Scott Hodgin 18.8k

votes

answers

views

Problems with Insert( simple query - can't think something )

sql-server sql-server-2008

Apr 4 '17 at 20:46 marc_s 7,238

votes

answers

255

views

Transform 14 columns into 2 (SQL Server 2008) - Pivot/Cursor not helping

sql-server pivot

Apr 4 '17 at 20:44 marc_s 7,238

votes

answer

views

How Can I Monitor SQL service with Zabbix?

sql-server-2014

Feb 14 '17 at 5:30 TechTips 1

votes

answer

views

Simple use of IF inside procedure

sql-server sql-server-2014

Dec 21 '16 at 12:30 Paul White♦ 57.6k

votes

answer

views

What does it mean when a table is listed with fragmentation?

sql-server-2014

Sep 19 '16 at 13:30 RLF 13.1k

votes

answers

614

views

How to PIVOT/UNPIVOT if I don't know how many columns will it have?

sql-server sql-server-2014 pivot

Jul 19 '16 at 18:56 Paul White♦ 57.6k

votes

answers

views

Is VSS Backup a better solution than the native backup?

backup sql-server-2014 best-practices vss

Jul 13 '16 at 11:17 Racer SQL 3,303

votes

answer

views

How can I insert this union all selects inside my procedure?

sql-server-2014

Jul 11 '16 at 10:51 Racer SQL 3,303

votes

answers

views

INSERT Trigger not inserting values

sql-server sql-server-2014 trigger

May 30 '16 at 21:09 Paul White♦ 57.6k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

167 Questions

How can I only UPDATE if the user was created?

Is there a better way to DENY SYS schema and INFORMATION-SCHEMA to DBO user?

How can I track if a trace is executing?

How to trace a query on Firebird?

Best idea to deal with historic data ( Partitioning? )

Firebird ODBC Setup - Linked server from SQL Server 2008 to FireBird Database

Different databases should have same scructure/values on tables

Problem with charset on SQL*PLUS

Help with a logic inside WHERE or ORDER BY

Stored procedure runs forever, but inner query runs fine

How to list LOGIN + ROLE in SQL Server 2008?

implement this query inside a cursor

Returning only duplicated data

Why is my cursor not stopping in the last table?

Concatenate with NULL values ( Should not replace NULL )

How to get rid of these Key Lookups?

How to make this query, to INNER JOIN with the schema?

Alter table Alter column Performance

simple RECOVERY mode, but with not static data

Hallengreen's Index maintenance query not using all indexes

Open Management Studio with configured connections

Problems with Insert( simple query - can't think something )

Transform 14 columns into 2 (SQL Server 2008) - Pivot/Cursor not helping

How Can I Monitor SQL service with Zabbix?

Simple use of IF inside procedure

What does it mean when a table is listed with fragmentation?

How to PIVOT/UNPIVOT if I don't know how many columns will it have?

Is VSS Backup a better solution than the native backup?

How can I insert this union all selects inside my procedure?

INSERT Trigger not inserting values