Profile Activity

Racer SQL

Meta user

Network profile

Reputation

6,214

6.2k
4.1k
2k

2017
2018
2019
2020

Next tag badge

sql-server

48/100 score

25/20 answers

Badges

Newest

Notable Question

Next badge

0/1

Impact

18 posts edited

46 helpful flags

584 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

193 Questions

Views Newest Activity Votes

votes

answers

views

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

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

votes

answers

views

Delete millions of rows disabling Indexes

sql-server sql-server-2014

Mar 23 '17 at 0:00 MDCCL 7,474

votes

answer

views

How to define the logical name in a backup ? ( Sql Server 2008 )

sql-server restore

Dec 29 '16 at 10:04 Community♦ 1

votes

answers

703

views

Is it possible to rebuild a dropped index?

sql-server performance sql-server-2014 bulk-insert query-performance

Jul 5 '16 at 17:52 Community♦ 1

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♦ 164k

votes

answers

309

views

How to create a JOB for Azure SQL?

azure-sql-database

Jan 13 at 20:15 shimon893 76

votes

answers

views

Strange Hostname/Application name when hunting for SA login errors [closed]

sql-server

Oct 15 at 17:28 Racer SQL 6,214

votes

answer

320

views

Availability Groups automatic failover is not so automatic

sql-server sql-server-2016 availability-groups clustering failover

Aug 27 at 19:31 Josh Darnell 16.7k

votes

answers

503

views

Do I need “New SQL Server Failover Cluster installation” to run Availability groups with manual failover?

sql-server-2014 availability-groups clustering

Aug 23 at 6:23 Shekar Kola 1,637

votes

answer

views

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

sql-server sql-server-2008-r2 performance pivot query-performance

Jul 7 at 6:00 Community♦ 1

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 6,214

votes

answer

376

views

Error when using views on a linked server

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

Mar 7 '19 at 13:50 Racer SQL 6,214

votes

answer

500

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 29.7k

votes

answer

658

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 - try topanswers.xyz 15k

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 58.2k

votes

answers

217

views

Strange Situation with sp_WhoIsActive

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

May 17 '17 at 6:57 sepupic 9,383

votes

answers

935

views

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

sql-server sql-server-2014

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

votes

answers

902

views

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

sql-server sql-server-2008

Sep 27 '15 at 19:34 marc_s 8,113

votes

answers

views

Use random string variable in a insert

sql-server sql-server-2008-r2 random

Sep 25 '15 at 3:57 Paul White 9♦ 51.5k

votes

answer

560

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 18.3k

votes

answers

511

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 60.8k

votes

answer

223

views

Help Changing Collate of ALL databases

sql-server-2008 collation

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

votes

answer

166

views

Improve OR inside INNER JOIN

sql-server sql-server-2008-r2 performance

Jun 14 at 16:39 Racer SQL 6,214

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 '19 at 19:41 Josh Darnell 16.7k

votes

answers

195

views

Enlighten me about INCLUDE on indexes

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

Jan 21 '19 at 10:52 KumarHarsh 1,405

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 '18 at 19:53 Racer SQL 6,214

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 6,214

votes

answer

106

views

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

sql-server sql-server-2012 schema

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

votes

answers

344

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,611

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 19.5k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

193 Questions

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

Delete millions of rows disabling Indexes

How to define the logical name in a backup ? ( Sql Server 2008 )

Is it possible to rebuild a dropped index?

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

How to create a JOB for Azure SQL?

Strange Hostname/Application name when hunting for SA login errors [closed]

Availability Groups automatic failover is not so automatic

Do I need “New SQL Server Failover Cluster installation” to run Availability groups with manual failover?

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

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?

Strange Situation with sp_WhoIsActive

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

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

Use random string variable in a insert

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

What to do with a table with too many indexes?

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

Is it possible to use LAG() with WHERE?