User Racer SQL

4

votes

1

answer

171

views

Delete unused indexes from Microsoft Dynamics CRM Application

Jul 25 '19 at 0:51 MDCCL 7,810

4

votes

1

answer

643

views

Problem when add administrator for Analysis Server ( SQL Server 2008 R2 )

sql-server-2008-r2 ssas

Jul 18 '19 at 12:35 Vojtěch Beran 1

4

votes

2

answers

4k

views

sys.sp_reset_connection. Why theres a lot of them ?

sql-server sql-server-2008-r2 connections

Apr 20 '19 at 18:42 Community♦ 1

4

votes

2

answers

2k

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

1

4

votes

3

answers

5k

views

Delete millions of rows disabling Indexes

sql-server sql-server-2014

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

2

4

votes

1

answer

3k

views

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

sql-server restore

Dec 29 '16 at 10:04 Community♦ 1

4

votes

2

answers

707

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

3

votes

0

answers

45

views

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

sql-server

Oct 15 '19 at 17:28 Racer SQL 6,599

3

votes

1

answer

474

views

Availability Groups automatic failover is not so automatic

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

Aug 27 '19 at 19:31 Community♦ 1

3

votes

3

answers

641

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 '19 at 6:23 Shekar Kola 2,148

3

votes

1

answer

4k

views

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

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

Jul 7 '19 at 6:00 Community♦ 1

3

votes

3

answers

203

views

Is there a problem creating only differential backups every hour?

sql-server sql-server-2008-r2 recovery

Apr 18 '19 at 12:22 Racer SQL 6,599

1

3

votes

1

answer

395

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

3

votes

1

answer

527

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

3

votes

1

answer

661

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

3

votes

1

answer

9k

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

3

votes

2

answers

242

views

Strange Situation with sp_WhoIsActive

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

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

1

3

votes

3

answers

974

views

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

sql-server sql-server-2014

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

3

votes

2

answers

5k

views

Is it possible to use LAG() with WHERE?

sql-server sql-server-2014 window-functions

Jan 12 '17 at 7:07 McNets 21.2k

3

votes

2

answers

916

views

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

sql-server sql-server-2008

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

3

votes

2

answers

2k

views

Use random string variable in a insert

sql-server sql-server-2008-r2 random

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

3

votes

1

answer

691

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.9k

3

votes

2

answers

659

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

3

votes

1

answer

266

views

Help Changing Collate of ALL databases

sql-server-2008 collation

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

2

votes

1

answer

213

views

Why BCP creates such big files?

sql-server sql-server-2012 bcp

Oct 7 at 15:02 Paul White♦ 58.5k

2

votes

2

answers

502

views

Is EXPDP the best backup approach when running Oracle on Windows with no RMAN?

oracle-12c

May 26 at 11:47 Community♦ 1

2

votes

1

answer

871

views

Importing BACPAC file from azure to SQL creating an empty database

sql-server-2016 azure-sql-database azure bacpac

Feb 27 at 10:11 wischi 131

2

votes

1

answer

37

views

Difference between SQL Server Azure and SQL Server 200x

azure-sql-database

Nov 26 '19 at 15:00 Alberto Morillo 1,412

2

votes

2

answers

518

views

Handling data encoding issues while loading data to SQL from Script (Notepad++)

sql-server oracle sql-server-2008 scripting encoding

Jun 21 '19 at 22:49 Solomon Rutzky 61.2k

2

votes

1

answer

171

views

Improve OR inside INNER JOIN

sql-server sql-server-2008-r2 performance

Jun 14 '19 at 16:39 Racer SQL 6,599

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

209 Questions

Delete unused indexes from Microsoft Dynamics CRM Application

Problem when add administrator for Analysis Server ( SQL Server 2008 R2 )

sys.sp_reset_connection. Why theres a lot of them ?

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?

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 it possible to use LAG() with WHERE?

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

Why BCP creates such big files?

Is EXPDP the best backup approach when running Oracle on Windows with no RMAN?

Importing BACPAC file from azure to SQL creating an empty database

Difference between SQL Server Azure and SQL Server 200x

Handling data encoding issues while loading data to SQL from Script (Notepad++)

Improve OR inside INNER JOIN