Can SQL Server system tables be defragmented?

Mar 2016 ⋅

⋅ ⋅ #fragmentation #system-tables #sql-server #sql-server-2014

SQL server databases stuck in restoring state

Jan 2014 ⋅

⋅ ⋅ #sql-server #sql-server-2012 #sql-server-2008-r2

How to reload a linked server?

Dec 2015 ⋅

⋅ ⋅ #linked-server #sql-server #sql-server-2014

ISO Week vs SQL Server Week

Mar 2013 ⋅

⋅ ⋅ #sql-server #sql-server-2008

Safe way to truncate SQL Server Error Log

Jan 2013 ⋅

⋅ ⋅ #disk-space #sql-server #truncate #errors #sql-server-2008-r2

Why does SQL Server Compute Scalar when I SELECT a persisted computed column?

Jun 2012 ⋅

⋅ ⋅ #execution-plan #sql-server #sql-server-2008

Can MySQL reasonably perform queries on billions of rows?

Jul 2012 ⋅

⋅ ⋅ #database-design #performance #mysql #sql

Why is using a table variable more than twice as fast as a #temp table in this specific case?

Feb 2012 ⋅

⋅ ⋅ #temp-tables #sql-server #sql

Oracle patching

Jun 2014 ⋅

⋅ ⋅ #oracle #sql

Query looks optimal but logical reads is huge

Apr 2015 ⋅

⋅ ⋅ #query-optimization #query-performance #sql-server #sql

Why am I getting Table scan on a partitioned table query?

Jul 2012 ⋅

⋅ ⋅ #partitioning #sql-server #sql #sql-server-2008 #sql-server-2008-r2

Postgres Count with different condition on the same query

Sep 2015 ⋅

⋅ ⋅ #postgresql #count #join #sql #postgresql-9.3

SQL Server 2012 Page Life Expectancy resets to 0 after about 50 days

May 2014 ⋅

⋅ ⋅ #page-life-expectancy #sql-server #sql-server-2012

Deadlock occurring on database, SQL Server 2008R2

Mar 2014 ⋅

⋅ ⋅ #sql-server #deadlock #sql-server-2008-r2

Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring

Jul 2017 ⋅

⋅ ⋅ #aggregate #spatial #oracle #sql #oracle-12c

Detect circular relations in a distribution table

Jul 2015 ⋅

⋅ ⋅ #many-to-many #constraint #firebird #sql

How does the operator & work in sql server?

Aug 2016 ⋅

⋅ ⋅ #sql-server #operator #sql-server-2014

Capitalize only the first letter of each word of each sentence in SQL Server

May 2016 ⋅

⋅ ⋅ #sql-server #sql #sql-server-2014

SQL Server CPU spikes - possibly non-query related - suggested indicators

Feb 2014 ⋅

⋅ ⋅ #service-broker #performance #monitoring #sql-server

Is this table in my ERD redundant? (Image)

Nov 2015 ⋅

⋅ ⋅ #database-design #mysql #erd #sql

Sql Server Reporting

Jun 2017 ⋅

⋅ ⋅ #sql-server #reporting #ssrs-2016

How can I change the target server type for a trace template?

Aug 2012 ⋅

⋅ ⋅ #sql-server #profiler

SQL INDEX - how it works?

Apr 2014 ⋅

⋅ ⋅ #index #sql

Is it fine to run a public website on the sql express db?

Sep 2011 ⋅

⋅ ⋅ #express-edition #sql-server-2008

SSMS 2014 (and 2012) CTRL+TAB requires pressing enter

Sep 2014 ⋅

⋅ ⋅ #ssms

Two relations to same table in SQL Server

Mar 2014 ⋅

⋅ ⋅ #relational-theory #constraint #sql-server

Is there a way to query SQL Server 2005/2008 for location of its log files?

Feb 2012 ⋅

⋅ ⋅ #sql-server #logs #sql-server-2008 #sql-server-2005

Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?

Dec 2014 ⋅

⋅ ⋅ #nonclustered-index #azure-sql-database #sql-server #sql

What sort of SPN / AD Computer Delegation do you need for delegation of credentials to a linked server

Apr 2016 ⋅

⋅ ⋅ #authentication #linked-server #sql-server #kerberos #sql-server-2008-r2

Getting database sizes on an MSSQL Server named instance

Oct 2015 ⋅

⋅ ⋅ #sql-server #t-sql #sql-server-2008-r2

Database Restore Failed Due to Incompatible Version of SQL Server

May 2013 ⋅

⋅ ⋅ #sql-server #restore

Factors to consider while Rebuild/Reorganize of index in SQL Server 2012

Feb 2017 ⋅

⋅ ⋅ #sql-server #index #sql-server-2012

Ideal values for wait time in SQL server

Jun 2014 ⋅

⋅ ⋅ #performance #wait-types #sql-server #sql-server-2008-r2

How to optimize NOT IN statement

Oct 2013 ⋅

⋅ ⋅ #optimization #index-tuning #sql-server #sql

How to enable multiple traceflags

Sep 2016 ⋅

⋅ ⋅ #sql-server #dbcc #sql

Why is this second query more expensive than the first?

Jul 2014 ⋅

⋅ ⋅ #query-performance #performance #oracle #index #sql

Compare two tables amount with respect to priortization of FundType

Sep 2012 ⋅

⋅ ⋅ #sql-server #query #sql

Where can I find a compatible version of SSMS for SQL Server 2016 CTP?

Dec 2015 ⋅

⋅ ⋅ #sql-server #ssms #sql-server-2016

Uninstalling SQL Server 2012, No option to select instance

Jan 2017 ⋅

⋅ ⋅ #installation #sql-server #sql-server-2012

NULLs in a composite primary key - SQL Server

Dec 2011 ⋅

⋅ ⋅ #entity-framework #sql-server #sql

Strange behaviour with Computed Columns in SQL-Server

Aug 2011 ⋅

⋅ ⋅ #sql-server

Why is Server Configuration in Pgadmin3 inaccessible for me?

May 2016 ⋅

⋅ ⋅ #postgresql #pgadmin

db_owner unable to drop database - Error 615, SQL Server

Feb 2014 ⋅

⋅ ⋅ #permissions #sql-server #amazon-ec2 #sql-server-2012

Error using an Execute SQL script to load a date variable in SSIS

Jun 2013 ⋅

⋅ ⋅ #sql-server #ssis #sql-server-2008-r2

Am I doing a security breach if I am connecting a MS-Access front end (multiple computers) to a SQL Server

Jul 2016 ⋅

⋅ ⋅ #sql-server #ms-access

Join To a @Table Variable is running ineficiently

Mar 2013 ⋅

⋅ ⋅ #stored-procedures #sql-server #view #sql #sql-server-2008

SQL 2012: Executed generated DB script in SQL 2008 R2

Sep 2016 ⋅

⋅ ⋅ #compatibility-level #stored-procedures #scripting #sql-server-2012 #sql-server-2008

Logical problem with a database model

Aug 2014 ⋅

⋅ ⋅ #relational-theory #sql-server #sql

How can I enforce a one-to-zero-or-one relationship with multiple types?

Dec 2016 ⋅

⋅ ⋅ #database-design #subtypes #sql

LIKE to select the independent existence of the word whereever in the text

Feb 2011 ⋅

⋅ ⋅ #pattern-matching #query #sql #sql-server-2008

sp_Blitz Findings: SQL Server Last Restart is an hour before Server Last Restart

Apr 2017 ⋅

⋅ ⋅ #sql-server #sp-blitz

How do I Delete A Database And Log Files With SQL 2008 Script?

Mar 2014 ⋅

⋅ ⋅ #scripting #delete #sql #sql-server-2008

Retrieve value of select query in a table column

Jul 2017 ⋅

⋅ ⋅ #sql-server #sql

Help with SQL Query to XML output

Dec 2014 ⋅

⋅ ⋅ #sql-server #t-sql #sql #xml

Dynamic SQL UNPIVOT and putting results into existing table

Oct 2016 ⋅

⋅ ⋅ #dynamic-sql #sql-server #unpivot #sql

SQL Server Express acting strange

Oct 2011 ⋅

⋅ ⋅ #performance #sql-server

Getting distinct list of records based on the MAX of a column

Sep 2013 ⋅

⋅ ⋅ #mysql #sql

Restoring a differential backup in SQL server 2005

Mar 2013 ⋅

⋅ ⋅ #sql-server #restore #backup #sql-server-2005

How to import export.sql in sql developer?

Jul 2015 ⋅

⋅ ⋅ #oracle-sql-developer #import

SQL Server Extended Event - How to reduce the fields of the event sql_statement_completed?

Oct 2016 ⋅

⋅ ⋅ #extended-events #sql-server

Service accounts for SQL Server 2012 only allow pre-Windows 2000 name?

May 2013 ⋅

⋅ ⋅ #sql-server #sql-server-2012

stats_date is null

Nov 2016 ⋅

⋅ ⋅ #index-statistics #statistics #sql-server #sql #sql-server-2016

Modeling a ticket system based on a set of disparate kinds of tickets?

Mar 2013 ⋅

⋅ ⋅ #relational-theory #database-design #sql

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

May 2011 ⋅

⋅ ⋅ #oracle-sql-developer #database-tuning #oracle

Sql Server 2012 Extended Events for Selective Xml Indexing not showing results

Jul 2013 ⋅

⋅ ⋅ #extended-events #sql-server #xml #sql-server-2012

Understanding & Resolving Deadlock in SQL Server 2008 R2

May 2015 ⋅

⋅ ⋅ #sql-server #deadlock #sql-server-2008-r2

Reporting on a normalized Key-Value pivot

Feb 2015 ⋅

⋅ ⋅ #normalization #sql-server #reporting #sql

How to get difference in value over 15min interval?

Mar 2016 ⋅

⋅ ⋅ #sql-server #sql #sql-server-2014

SQL Server Always On Node and File Share Majority

Feb 2017 ⋅

⋅ ⋅ #availability-groups #high-availability #disaster-recovery #sql-server #clustering

Perfmon and SQL Server Clustering

Sep 2014 ⋅

⋅ ⋅ #clustering #profiler #perfmon #windows-server-2008-r2 #sql-server-2008-r2

Trouble setting up mirroring on SQL Server 2016

Mar 2016 ⋅

⋅ ⋅ #sql-server #mirroring #sql-server-2016

Are the cost percentages in this SQL Server plan over 100% for a valid reason?

Apr 2013 ⋅

⋅ ⋅ #execution-plan #sql-server #ssms #sql-server-2012

Trigger is not working in SQL Server 2012 on runtime?

Mar 2016 ⋅

⋅ ⋅ #sql-server #trigger #sql-server-2012

How to add foreign key with more than 1 field in SQL Power Architect

Nov 2015 ⋅

⋅ ⋅ #erd

SQL Server 2016 Bad Query Plan locks up DB once a week

Apr 2017 ⋅

⋅ ⋅ #2016

SQL Server Transactional Replication snapshot delivery loop

Mar 2017 ⋅

⋅ ⋅ #transactional-replication #sql-server

Encoding issue with SQL Server VARCHAR column retrieved in Python

Aug 2017 ⋅

⋅ ⋅ #sql-server #encoding #python #utf-8 #sql-server-2008-r2

Should I nest dependent outer joins in SQL Server?

Feb 2014 ⋅

⋅ ⋅ #performance #join #sql #sql-server-2008-r2

SQL 2012 Autogrow and file extension problem

Oct 2015 ⋅

⋅ ⋅ #auto-growth #sql #sql-server-2012

Sudden Query Performance Degradation On A Linked Server

Aug 2012 ⋅

⋅ ⋅ #query-performance #linked-server #sql-server-2008 #sql-server-2008-r2

SQL Server 2008 R2 Restore constantly hanging

Jan 2014 ⋅

⋅ ⋅ #restore #sql #sql-server-2008-r2

Indexing strategy when using the between operator SQL Server 2008

Feb 2013 ⋅

⋅ ⋅ #optimization #sql-server #index #sql

How to model inheritance of two tables mysql

Mar 2013 ⋅

⋅ ⋅ #database-design #mysql #sql

Composite key as foreign key of multiple tables

May 2017 ⋅

⋅ ⋅ #database-design #erd #sql

Single Virtual Drive Vs Multiple Virtual Drives for SQL Server files

Sep 2014 ⋅

⋅ ⋅ #virtualisation #sql-server #hardware #sql-server-2008-r2

De-duplication method for fields that are identical except for Unique ID

Mar 2016 ⋅

⋅ ⋅ #duplication #ms-access #sql

set SPN on SQL cluster

Nov 2016 ⋅

⋅ ⋅ #sql-server #kerberos #spn #sql-server-2014

How do I create a SQL Agent Alert on a custom error message in SQL Server 2012?

Jan 2016 ⋅

⋅ ⋅ #2012

Improve SQL Performance with LIKE '%ABC%' QUERY

Apr 2015 ⋅

⋅ ⋅ #azure-sql-database #sql-server #sql

What should my SPN entries look like for each SQL instance?

Jul 2017 ⋅

⋅ ⋅ #sql-server #kerberos #spn

MS Access displays alle columns in SQL Server tables as deleted

Jun 2011 ⋅

⋅ ⋅ #sql-server #ms-access #odbc #sql-server-2005

Best way to design tournament database

Nov 2011 ⋅

⋅ ⋅ #database-design #mysql #sql

How do I map SSIS 2012 Package Variables to Parameters?

Dec 2013 ⋅

⋅ ⋅ #environment-variables #ssis-expressions #ssis-2012

Is there a name for a query that returns results which have sub headings?

Sep 2012 ⋅

⋅ ⋅ #reporting #query #sql

Pulling Top queries returns NULL in query plan and sql text

Sep 2014 ⋅

⋅ ⋅ #sql-server #top #sql #dmv

find all numbers that appear at least three times consecutively

Jan 2015 ⋅

⋅ ⋅ #mysql #sql

Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?

Dec 2012 ⋅

⋅ ⋅ #service-broker #sql-server #sql #sql-server-2005

I cannot get SQL Server 2012 to install the database engine

Sep 2012 ⋅

⋅ ⋅ #sql-server #clustering #sql-server-2012

Optimize query with join and null predicate [SQL Server]

May 2017 ⋅

⋅ ⋅ #azure-sql-database #index-tuning #sql-server #sql

SQL Server ODBC Mirror/Failover Partner

Aug 2012 ⋅

⋅ ⋅ #sql-server #ms-access #mirroring #failover #odbc

SQL Server 2008 R2 Partitioning - same FileGroup, 1 File, 2 partition_numbers - HELP

May 2015 ⋅

⋅ ⋅ #partitioning #sql-server #sql-server-2008-r2

SQL Server performance issue (CXPACKET wait type)

Mar 2017 ⋅

⋅ ⋅ #optimization #performance #wait-types #sql-server #sql-server-2012

Calculating daily growth using previous row value in new column - SQL Server

Aug 2015 ⋅

⋅ ⋅ #sql-server #t-sql #sql

T-SQL - How to filter data from table

Nov 2013 ⋅

⋅ ⋅ #sql-server #sql

What does this SQL Server icon mean?

Mar 2014 ⋅

⋅ ⋅ #sql-server #ssms

I can't create relationship in my database sql server

Jan 2015 ⋅

⋅ ⋅ #database-design #sql-server #insert #sql

Unable to uninstall Sql Server 2012 Express (With SP1)

Sep 2015 ⋅

⋅ ⋅ #installation #sql-server #windows-10 #sql-server-2012

Move (Restore) SQL Server 2005 database which does not exist before

Mar 2012 ⋅

⋅ ⋅ #permissions #sql-server #restore #backup #sql-server-2005

SQL Server 2016 Query Crashes Server

Jun 2016 ⋅

⋅ ⋅ #sql-server #memory

Cannot start SQL Server replication as already running

Jul 2014 ⋅

⋅ ⋅ #replication #sql-server-2012

Updating rows in a large table in sql server

Mar 2017 ⋅

⋅

How to minimize log operations in SQL Server to avoid log full error

May 2015 ⋅

⋅

Two Connect SQL permissions in SQL Server 2012

Jan 2014 ⋅

⋅ ⋅ #permissions #security #sql-server-2012

Reset the numbering at the tabs of the Microsoft SQL Server Management Studio

Sep 2012 ⋅

⋅ ⋅ #ssms #sql-server-2008

Registered Server window does not show Database Engine or Local Server Groups

Mar 2015 ⋅

⋅ ⋅ #ssms #sql-server-2012

SSIS 2012 VS_ISBROKEN on Derived Column

Jan 2017 ⋅

⋅ ⋅ #ssis-expressions #sql-server #ssis #ssis-2012

The connection is broken and recovery is not possible - sql server error

Jul 2015 ⋅

⋅

Tracking Down Application Timeout Errors in SQL Server

Oct 2014 ⋅

⋅ ⋅ #query-timeout #connectivity #sql-server

I need help optimizing a not that complicated query that returns unexpedcted performance problems

Jul 2014 ⋅

⋅ ⋅ #mariadb #mysql #index #sql

How can I guarantee that inserts to SQL Server 2008 R2 are cached in RAM first?

May 2011 ⋅

⋅ ⋅ #sql-server #c# #visual-studio-2010 #sql-server-2008

SQL Server: dm_exec_requests.wait_time vs. dm_exec_sessions.last_request_end_time

Sep 2015 ⋅

⋅ ⋅ #sql-server #waits #dmv #sql-server-2012

How to improve this union to ensure consistent results?

Jan 2016 ⋅

⋅ ⋅ #postgresql #sql #postgresql-9.5 #postgresql-9.4

Slot Time Challenge - Doctor Appointment database schema

May 2016 ⋅

⋅ ⋅ #database-design #sql-server #schema #sql

Investigating high SQL waits, especically LCK_M_U

Mar 2013 ⋅

⋅ ⋅ #performance #wait-types #sql-server-2008

SQL Server Management Studio 2016 (Release 16) keeps on crashing

Aug 2016 ⋅

⋅ ⋅ #memory #ssms #sql-server-2016

Selecting from a table contains a XML column

Feb 2016 ⋅

⋅ ⋅ #sql-server #import #sql #xml

Better way to select from nested tables in PostgreSQL

Mar 2015 ⋅

⋅ ⋅ #postgresql #subquery #select #join #sql

Configuring SQL Server 2016 to allow remote connections

Nov 2015 ⋅

⋅ ⋅ #windows-server-core #windows-server #sql-server #sql-server-2016

Windows could not start the SQL Server (mssqlserver) service on local computer error 17058

Dec 2013 ⋅

⋅ ⋅ #sql-server #sql

Removing Instances and SQL Server Express edition and going to Standard/Developer/Enterprise

Dec 2011 ⋅

⋅ ⋅ #sql-server-express #ssms #sql-server-2008

Problem adding a new node to a SQL Server 2012 Failover Cluster

Jun 2013 ⋅

⋅ ⋅ #sql-server #clustering #failover #sql-server-2012

SQL Server access issue

Feb 2016 ⋅

⋅ ⋅ #connectivity #sql-server #sql-server-2012

SQL Server Restore w/o Closing Existing Connections

Apr 2015 ⋅

⋅ ⋅ #sql-server #restore

Duration unit in SQL Server trace file

Mar 2017 ⋅

⋅ ⋅ #performance #sql-server #trace #sql-server-2012

Why do async_network_io wait types occur?

Jul 2015 ⋅

⋅ ⋅ #entity-framework #sql-server #sql #sql-server-2008

SQL Server detected a logical consistency-based I/O error: incorrect pageid on RESTORE

Feb 2017 ⋅

⋅ ⋅ #dbcc-checkdb #sql-server #restore #sql-server-2016

SQL, SQLCLR objects & effective memory utilization

Jul 2016 ⋅

⋅ ⋅ #performance-tuning #sql-server #sql-clr #memory #sql-server-2012

How to change name for administrator login on azure sql server

Jan 2015 ⋅

⋅ ⋅ #azure-sql-database #management

Reporting services existing in SQL Cluster instance but unable to see on SSMS?

May 2017 ⋅

⋅ ⋅ #sql-server #clustering #failover #ssrs

SQL Server 2008 Full Text Index Never Seems to Complete

Nov 2011 ⋅

⋅ ⋅ #sql-server-express #full-text-search #sql-server #sql-server-2008-r2

How to get one MAX() between SUMs of several columns in SQL?

Apr 2016 ⋅

⋅ ⋅ #max #sum #sql

Performance improvement Outer Apply

Jun 2017 ⋅

⋅ ⋅ #performance-tuning #cross-apply #sql-server #t-sql #sql

Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?

Sep 2013 ⋅

⋅ ⋅ #performance-testing #surrogate-key #natural-key #sql-server #sql-server-2012

Query 100x slower in SQL Server 2014, Row Count Spool row estimate the culprit?

Oct 2015 ⋅

⋅ ⋅ #cardinality-estimates #query-performance #sql-server #sql-server-2014

Replication Monitor Information using T-SQL

Jan 2015 ⋅

⋅ ⋅ #transactional-replication #merge-replication #replication #sql-server #sql-server-2005