Profile Activity

Racer SQL

Meta user

Network profile

Reputation

3,333

3.3k
1.9k
500

2016
2017
2018
2019

Next tag badge

sql-server

44/100 score

21/20 answers

Badges

Newest

Next badge

96/100

Impact

18 posts edited

44 helpful flags

516 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

168 Questions

Views Newest Activity Votes

votes

answer

views

How can we improve this PIVOT operation? ( SQL Server 2008 R2 )

Jul 7 at 6:00 Community♦ 1

votes

answers

views

sys.sp_reset_connection. Why theres a lot of them ?

sql-server sql-server-2008-r2 connections

Apr 20 at 18:42 Comment Converter 1,497

votes

answers

views

Is there a problem creating only differential backups every hour?

sql-server sql-server-2008-r2 recovery

Apr 18 at 12:22 Racer SQL 3,333

votes

answer

356

views

Error when using views on a linked server

sql-server sql-server-2008 view linked-server

Mar 7 at 13:50 Racer SQL 3,333

votes

answer

454

views

Best practices on dealing with devs that want to use XP_CMDSHELL to BCP OUT

sql-server sql-server-2008

Apr 17 '18 at 16:07 Erik Darling 25.9k

votes

answer

655

views

Why is my database using Partitioning? ( I know it's not )

sql-server sql-server-2008

Mar 13 '18 at 12:27 Tom V 14.2k

votes

answer

views

How to be sure that a SQL Script is running with ANSI encoding?

sql-server sql-server-2008-r2 encoding unicode

Nov 9 '17 at 17:00 Solomon Rutzky 51.5k

votes

answers

views

Trace to find “error messages”( SQL Server 2008 R2 )

sql-server sql-server-2008-r2 trace

Nov 9 '17 at 14:04 Paul White♦ 57.8k

votes

answers

915

views

How to do SUM() but with some rules to follow?

sql-server sql-server-2014

Mar 30 '17 at 9:07 Scott Hodgin 18.9k

votes

answers

882

views

Is SQL Server 2008 going to be obsolete “soon”?

sql-server sql-server-2008

Sep 27 '15 at 19:34 marc_s 7,258

votes

answer

478

views

Query to list “last backup time” listing wrong times ( SQL Server 2008 R2 )

sql-server sql-server-2008-r2 t-sql

Sep 16 '15 at 16:06 Andriy M 17.1k

votes

answers

408

views

What to do with a table with too many indexes?

sql-server sql-server-2008 index

Sep 15 '15 at 19:04 Max Vernon 54.8k

votes

answers

views

List all databases of a certain user ( SQL Server 2008 R2 )

sql-server-2008-r2 permissions

Aug 21 '15 at 3:22 Aaron Bertrand♦ 158k

votes

answer

196

views

Help Changing Collate of ALL databases

sql-server-2008 collation

Jan 6 '15 at 3:26 Michael Green 15.5k

votes

answer

155

views

Improve OR inside INNER JOIN

sql-server sql-server-2008-r2 performance

Jun 14 at 16:39 Racer SQL 3,333

votes

answers

379

views

Is it a good idea to use COLUMN AS (left([Another_Column],(4)) instead of LEFT in the select?

sql-server sql-server-2008-r2 t-sql

Mar 28 at 19:41 Josh Darnell 10.7k

votes

answers

163

views

Enlighten me about INCLUDE on indexes

sql-server sql-server-2008-r2 index-tuning

Jan 21 at 10:52 KumarHarsh 1,028

votes

answer

views

Is database partitioning only created to get a better performance? and why should one partition a table, and a database? [closed]

sql-server sql-server-2008-r2 partitioning

Nov 5 at 19:53 Racer SQL 3,333

votes

answer

views

It is possible to extract Extented Properties using SQL Developer Data Modeler?

sql-server-2008-r2

Jan 12 '18 at 17:44 Racer SQL 3,333

votes

answer

views

Simple question about schema (is this supposed to happen?)

sql-server sql-server-2012 schema

Aug 1 '17 at 6:30 Michael Green 15.5k

votes

answers

299

views

Select only databases with a certain table name and specific columns

sql-server sql-server-2008-r2 join

Jul 13 '17 at 14:37 Stijn Wynants 1,511

votes

answers

171

views

Strange Situation with sp_WhoIsActive

sql-server sql-server-2008-r2 sp-whoisactive

May 17 '17 at 6:57 sepupic 7,944

votes

answers

views

Is it possible to use LAG() with WHERE?

sql-server sql-server-2014 window-functions

Jan 12 '17 at 7:07 McNets 16.8k

votes

answer

views

What does “ISO standard equivalent” actually mean?

sql-server sql-server-2014 terminology sql-standard

Nov 29 '16 at 13:33 Paul White♦ 57.8k

votes

answer

611

views

Fast local backup - Very slow backup via Network

sql-server-2008-r2 backup network

Oct 21 '16 at 19:53 EzE 1

votes

answers

views

Correct way to uninstall SQL Server 2008 ( or above )

sql-server sql-server-2008 installation

Sep 29 '16 at 6:36 DerpyNerd 101

votes

answers

views

Create a monthly job to export from SQL Server 2014 to Excel

sql-server sql-server-2014 export excel

Jun 8 '16 at 14:10 LowlyDBA 7,521

votes

answers

246

views

I'm confused about High Availability/Always On

sql-server sql-server-2014 availability-groups high-availability

May 1 '16 at 20:45 Paul White♦ 57.8k

votes

answer

views

How to know which query is resulting in errors in the trace?

sql-server sql-server-2014 trace

Mar 14 '16 at 3:05 Paul White♦ 57.8k

votes

answers

views

What does 'Could not find a log backup file that could be applied' means on log shipping?

sql-server-2012 log-shipping

Dec 10 '15 at 20:32 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

168 Questions

How can we improve this PIVOT operation? ( SQL Server 2008 R2 )

sys.sp_reset_connection. Why theres a lot of them ?

Is there a problem creating only differential backups every hour?

Error when using views on a linked server

Best practices on dealing with devs that want to use XP_CMDSHELL to BCP OUT

Why is my database using Partitioning? ( I know it's not )

How to be sure that a SQL Script is running with ANSI encoding?

Trace to find “error messages”( SQL Server 2008 R2 )

How to do SUM() but with some rules to follow?

Is SQL Server 2008 going to be obsolete “soon”?

Query to list “last backup time” listing wrong times ( SQL Server 2008 R2 )

What to do with a table with too many indexes?

List all databases of a certain user ( SQL Server 2008 R2 )

Help Changing Collate of ALL databases

Improve OR inside INNER JOIN

Is it a good idea to use COLUMN AS (left([Another_Column],(4)) instead of LEFT in the select?

Enlighten me about INCLUDE on indexes

Is database partitioning only created to get a better performance? and why should one partition a table, and a database? [closed]

It is possible to extract Extented Properties using SQL Developer Data Modeler?

Simple question about schema (is this supposed to happen?)

Select only databases with a certain table name and specific columns

Strange Situation with sp_WhoIsActive

Is it possible to use LAG() with WHERE?

What does “ISO standard equivalent” actually mean?

Fast local backup - Very slow backup via Network

Correct way to uninstall SQL Server 2008 ( or above )

Create a monthly job to export from SQL Server 2014 to Excel

I'm confused about High Availability/Always On

How to know which query is resulting in errors in the trace?

What does 'Could not find a log backup file that could be applied' means on log shipping?