My Love with SQL Server

Anything about SQL Server

Select a Tag

Tag	Scoops
.net	1
1118	1
17883	1
17884	1
17887	1
17888	1
18065	1
18456	1
33204	1
9130	1
aborted connections	1
access	1
active transactions	1
activity	1
ad-hoc	1
adaptive	1
add-in	2
addition	1
adjacency list	1
administration	12
aduiting	1
adventureworks	1
AG	1
algorithm	1
aligned partitioned parallel index build	1
all-in-one	1
all-in-one reference guide	1
allocation	1
allow page locks	1
allow row locks	1
ALTER SERVER CONFIGURATION	1
alteration	1
always on	1
alwayson	20
analysis	9
analysis engine	2
analysis services	8
analytical queries	1
anatomy	2
anaylysis services	1
anti-virus	3
approach	1
architecture	5
archival	1
archiving strategy	2
arithmetic overflow	1
artifacts	1
assessment	1
asynchronous	1
asynchronous operations	3
audit	3
auditing	1
authentication	1
auto update	1
autoallocation	1
automatic failover	1
automation	2
availability	9
availability gorups	2
availability group	3
availability groups	7
azure	3
backup	8
backup and recovery	3
backup and restore	4
backup location	1
backup process	1
backups	4
baseline	3
basics	2
bcp	3
benchmark	3
benchmarks	2
best approaches	1
best method	1
best practice	8
best practices	33
best standards	1
bi	9
BI architect	1
bi features	1
BI projects	1
bi semantic model	1
bi suite	1
big data	4
big table	1
bigadventure	1
bigint	1
bit map	1
bitmap	1
black box recorder	1
blob	3
blobeater	1
blocking	3
blog	4
BOM	1
bottleneck	1
boundary	1
buffer	1
buffer latch	1
buffer poll	1
buffer pool	1
buffer rings	1
builds	2
built-in	1
bulk copy	1
bulk copy command	1
bulk insert	1
bulk inserts	1
bulk logging	1
business inetlligence	3
business intelligence	7
business intelligence solution	1
cache	1
caching	4
CAL licensing	1
calculation	1
capacity planning	4
cardinality	4
career	1
career path	2
case studies	1
case study	1
cdc	4
certifcation	1
certificates	1
certification path	1
challenges	1
change data capture	3
change tracking	1
changes	1
cheat-sheet	1
cheatsheet	1
checkdb	1
checklist	1
checksum	1
clause	1
cleansing and matching	1
cloning	1
cloud	3
CLR	2
clr stored procedures	1
cluster	2
cluster instances	1
clustered index	2
clustered indexes	1
clustering	6
coalesce	1
code	10
code development	1
code writing	1
codeplex	4
coding	5
collaboration	2
collation	3
column	1
column store	2
columnar database	1
columns	1
columnstore	3
columnstore index	8
columnstored index	1
common table expressions	1
communication	1
community	1
comparison	3
comparison chart	1
competition	1
complex	1
complex test databases	1
composite key	1
composite projects	1
compressed rowsets	1
compression	6
compute scalar	1
compute scalars	1
computed-column	1
concurrency	3
conditional order by	1
configuration	35
configurations	2
connections	4
connectivity	5
connectivity issues	1
constraint violations	1
constraints	1
consulting	1
contained databases	2
contained dbs	1
contained logins	1
contentions	1
contents	1
conventional implementation	1
conversation	1
conversion	2
core	1
corruption	1
cost	1
counters	2
cpu	8
cpu pressure	2
create	2
creation	1
criteria	1
crm	1
cross tab report	1
csv	1
CTE	2
ctp	1
cube	1
cumulative updates	1
cursor	1
customizing	1
dac	3
data	9
data analysis	1
data architecture	2
data caching	1
data centers	1
data cleansing	1
data explorer	1
data file	1
data files	1
data filtering	1
data flow	1
data mart	1
data mining	3
data model	1
data modeling	1
data pages	1
data privacy	1
data profiling task	1
data pump	1
data quality service	1
data quality services	5
data science	1
data tools	1
data type	3
data types	2
data validation	1
data visualization	1
data warehouse	1
database	16
database administration	2
database corruption	1
database design	1
database engine	2
database federation	1
database growth	1
database i/o	1
database life cycle management	1
database migration	1
database mirroring	4
database movement	2
database online	1
database principles	1
database recovery	2
database recovery advisor	1
database statistics	1
database usage	1
databases	2
datatype	1
datawarehouse	2
datetime	4
datetime value	1
dax	3
db mirroring	3
db restore	1
dbcc	4
dbcc checkdb	6
dbcc ind	1
ddl operations	1
deadlock	2
deadlock graph	1
deadlocks	5
deallocation	1
debug	1
dedicated administrator connection	1
deep joins	1
definition	1
defragmentation	1
delete	1
deletes	1
deletion	1
demo	1
demos	1
deployment	15
deployments.	1
depreciation features	1
design	12
developer training kit	1
development	13
diagnosis	4
dialog	1
difference	2
differences	4
differential	1
differential backup	1
direct query	1
dirty reads	1
disaster ercovery	1
disaster recovery	3
disaster recovery planning	1
discovery	1
disk	3
disk configuration	1
disk io	1
disk subsystem	3
distinct aggregation	1
distributed query plan	1
distributed replay	2
distributed transaction coordinator	1
distribution	1
dmf	2
dmfs	1
dml	3
dml operations	1
dmv	8
dmvs	8
dm_db_index_physical_stats	1
document	1
documentation	1
documentor	1
documents	1
domain rules	1
DOP	1
dos and donts	1
dqs	6
DR	2
DR solution	1
drop clustered index	1
drop table	1
dtc	1
duplicate index	1
dw	2
dynamic search	1
dynamic sql	2
EAV	1
ebook	1
ebooks	1
edition	1
editions	1
EDW	1
effect	2
effects	1
elimination	1
elt	1
encryption	1
enforcement	1
engine	1
enhance performance	1
enhancements	1
enterprise	2
enterprise datawarehouse	1
enterprise edition	1
entity	1
entity framework	1
environment	1
error	4
error handling	3
error handling techniques	1
error logging	1
error messages	1
errors	1
estimates	2
estimation	3
ETL	1
etl	1
evaluate	1
evaluation	2
evaluation edition	1
event notification	1
event viewer	1
example	1
excel	1
excel 2010	1
excel 2013	2
exception handling	1
exceptions	1
execution	1
execution memory grants	1
execution plan	22
execution plans	2
expiry	1
expiry date	1
export	2
exporting photos	1
expressions	1
extended events	13
extended events manager	1
facets	1
facts	1
failover	4
failover cluster instances	2
failover clustering	3
failovers	1
failure	1
failures	1
fast data push	1
fast table	1
fault-tolerance	1
feature	3
features	5
federated database	1
file	1
file layout	2
file server	1
file stream	1
file system	1
filegroup	2
filegroups	3
files	5
filestream	1
filetable	2
filetables	1
filter	2
filtered index	3
filtered statistics	1
find	1
findings	1
fix	4
fixes	4
fixing	3
flexibility	1
flowchart	1
fn_dblog	1
forced parameterization	1
forecasting	1
foreign key	1
foreign keys	3
forumulae	1
forward ghosts	1
fragmentation	3
framework	2
free	3
free ebooks	1
free tools	3
frequency	1
full backup	1
full recovery model	1
full restore	1
full-text	3
function	2
functionals	1
functions	2
fundamentals	4
gallery	1
geometry	2
graph	1
graphical execution plan	1
grid results	1
growth	2
guidance	3
guide	10
guidelines	8
HA	2
hadoop	3
hadron	1
halloween	4
hammerora	1
hard disk	1
hardware	4
hardware selection	1
hardware sizing	1
hdinsight	1
health	3
health check	1
health session	1
hierarchy	2
high availability	7
high availability solutions	1
high utilization	2
hints	1
history	1
how & what	1
how it works	1
hybrid data movement	1
hyper-v	1
hyperthreading	1
hypothetical	1
IaaS	1
idempotency	1
identity	1
identity column	1
identity delegation	1
identity values	1
ignore_dup_key	1
impact	1
implementation	32
implementation guidelines	1
implementation methods	1
implementation steps	2
implicit conversions	1
implicit data type conversion	1
import	3
importance	1
IN	1
in-memory	1
in-memory analytics	1
index	29
index build strategy	5
index building strategy	2
index fragmentation	1
index internals	1
index physical stats	1
index scans	1
index usage	1
index usage stats	1
indexed view	1
indexed views	1
indexes	2
indexing	4
indirect checkpoint	1
injection	1
insert	1
inserts	2
insight	4
insights	3
installation	4
installation steps	1
installations	1
instance	1
instance host	1
instant file initialization	1
integer	1
integration	2
integration services	25
internal	2
internal functions	1
internals	70
interval	1
intra-query parallelism	1
introduction	1
inverted join	1
IO	5
IO stalls	1
iops	1
isolation	1
isolation level	1
isolation levels	2
issue	2
issues	6
join	1
joins	2
kb	1
kerberos	1
key	1
key column	1
key lookup	1
key lookups	3
key phrases	1
key terms	1
klout	1
laboratory	1
large objects	1
large scale	1
latches	1
latency	1
layout	1
leaf member attributes	1
leaks	1
learning	1
lease	1
license core	1
licensing	4
life cycle	1
life-saver	1
light locking	1
limitation	1
linked server	1
links	2
listing	1
live monitor	1
load test	1
load testing	1
load-sharing	1
loading	1
LOB	3
LOB pages	2
local db	1
lock	1
lock resource	1
locking	4
log	1
log file	2
log sequence numbers	1
log shipping	1
logging	5
logical cores	1
logical reads	1
logical structure	1
login failed	1
logs	1
lookup cache	2
low-maintenance	1
lync	1
maintain	1
maintenance	24
maintenance and support	1
maintenance plans	1
management	2
management data warehouse	2
management studio	2
mapped drives	1
master data services	3
MAXDOP	1
maxdop	1
MCSM	1
mdac	1
mdm	2
mds	3
mdx	2
MEAPS	1
measure	1
measures	1
median	1
median calculation	1
memory	9
memory access patterns	1
memory error recovery	1
memory grant	1
memory leak	1
memory manager	3
memory pressure	1
merge	5
merge replication	3
merging boundary points	1
message queues	1
metadata	3
method	5
methodologies	4
methodology	9
methods	3
microsoft	4
migrate	1
migration	9
migration guide	1
minimal downtime	1
mirroring	2
missing index	1
missing transaction log	1
mission-critical	1
mistakes	1
modeling	1
modes	1
monitor	2
monitoring	34
monthly	1
movement	1
moving large files	1
MSDB	1
msft	1
multi-instance	2
multi-tenant	1
multidimensional	1
multiple composite client-specific db	1
multiple languages support	1
multiple versions	1
myths	1
named instance	1
nested partitioned views	1
nested sets	1
network	2
network binding order	1
new feature	1
new features	5
nmap	1
no histogram	1
no partition	1
no partitioning	2
node	1
nodes	1
nolock	1
non clustered index	2
non-aligned partitioned	2
nonescalation	1
nonpooling	1
normalization	1
nosql	1
number of files	1
objective	1
objects	1
objects - files - filegroups	1
observer overhead	1
office 2013	1
Office 2013	1
office 365	1
offline	7
oltp	3
olympics	1
online	1
open source	2
operating system	1
operators	4
optimization	3
optimizer	7
options	2
oracle	5
oracle dbas	1
output	1
OUTPUT clause	1
over clause	1
overhead	1
packages	1
page	2
page density	1
page splits	1
page structure	2
pages	2
pal	1
paper	1
parallel	6
parallel execution plans	1
parallel partitioning	1
parallel query processing	1
parallelism	4
parameterization	2
parse	1
parsing	1
partially contained databases	2
partition	3
partition elimination	1
partition processing destination task	1
partition switch	1
partitioned views	1
partitioning	7
partitioning in locking and deadlocks	1
patches	2
pause	1
PBM conditions	1
perfmon	2
performance	231
performance analysis	1
performance analysis services	1
performance counter	1
performance counters	3
performance evaluation	3
performance impact	2
performance management datawarehouse	1
performance monitoring	2
performance overheads	2
performance point	1
performance testing	1
performance tuning	1
permissions	1
physical	2
physical cores	1
physical ordering	1
physical read	1
physical sockets	1
physical tables	1
plan	1
plan cache	3
plan caching	2
platform	1
point-in-time-restore	1
policies	1
policy	1
policy-based management	1
pool	1
pooling	2
port	1
porting	1
poster	1
power pivot	1
power view	3
powerpivot	3
powershell	4
practice	1
predicates	1
preview	1
pricing	1
primary key	2
priority	1
procedure	3
procedure cache	1
process	1
process monitor	1
processing time	1
processor	1
processors	1
product update	1
production	2
productivity	1
profiler	2
programming	2
project	1
pros-cons	1
protocol	2
puzzle	1
puzzles	1
quality	1
queries	5
query	10
query engine	1
query execution plan	1
query load testing	1
query optimizer	4
query plan	2
query plans	1
query processing	1
query processor	1
query response	1
query stats	1
query writing	1
querying	2
querytraceon	1
queues	2
RAID	1
range	1
ranking functions	1
rdbms	2
read	1
read-only	2
reads	2
real-time	1
real-time integration	1
reason	1
rebuild	2
recommendations	1
recompilation	2
record	1
record linkage	1
records	1
recover	1
recovery	8
recovery advisory tool	1
recovery model	2
recovery point objective	1
recovery time objective	1
recursive numbers	1
redgate	1
refactoring	1
reference	4
reference data	1
reference guide	1
registry keys methods	1
relationships	1
release	1
replace	1
replication	6
report	1
report content manager	1
reporting	3
reporting pack	1
reporting server	1
reporting services	3
repository	1
requirements	1
research papers	1
resilience	1
resource governor	2
resources	5
response time	1
restore	8
restores	1
retrievedfromcache attribute	1
ring buffer	2
routines	1
routing	1
row	1
RPO	1
RTO	1
rules	1
running totals	1
sample	1
samples	1
SAN	1
SAP	1
SAP deployment	1
sargable	1
sargable queries	1
scalability	5
scalable	1
scalar functions	2
scale	2
scale-out	2
scaling	2
scan	1
scanning	1
sch-locks	1
scheduled tasks	1
scheduler	1
scheduling	1
schema compare	1
schema comparison	1
scheme	1
scope	1
script	6
scripts	9
secondary	1
secondary database	1
security	2
security update	1
seek	1
segment distribution	1
selective	1
selectivity	1
self-service BI	2
semantic	1
semantic search	2
sensor	1
sequence	2
serial	5
series	2
service broker	6
service pack	1
service pack 1	1
service packs	2
services	2
session	1
setting	1
setup	5
shared memory	1
sharepoint	3
sharepoint 2013	1
sharepoint integrated mode	2
show plan	1
showplan	1
shredding	1
shrink	1
shrinking	1
shrinking data	1
shutdown	1
side effect	1
simulation	1
single operation	1
size	2
sizing	3
sizing sample	1
SMB	1
snac	1
snippets	2
soft errors	1
solution	2
sort order	2
sp1	1
sp2	1
space availability	1
space issues	1
sparse	1
sparse columns	1
spatial	1
specifications	1
split	3
splitting strings	2
sqequential read ahead	1
sql	4
sql agent job	1
sql azure	9
SQL cluster	1
sql injection	1
sql monitor	1
SQL on Cloud	1
sql os	1
sql server	649
sql server 2000	2
sql server 2005	66
sql server 2008	241
sql server 2008 r2	234
sql server 2008 sp1	1
sql server 2012	294
sql server agent	1
sql server analysis services	1
sql server azure	1
sql server clustering	1
sql server data tools	2
sql server developer tools	1
sql server developers tools	1
sql server engine	1
sql server error log	1
sql server integration services	2
SQL Server internal viewer	1
sql server inventory	1
sql server management studio	1
sql server service broker	1
sql sever	1
sql srever	1
SQL test	1
sql trace	1
sqlcat	1
sqlclient	1
sqlconnection	1
sqldiag	1
SQLIO	1
sqlioism	1
SQLIOSIM	2
ssas	7
ssas partition	1
ssb	1
SSB	1
ssd	1
ssdt	9
ssis	19
ssis catalog	3
ssis catalog sp	2
ssis fuzzy matching	1
ssms	6
ssrs	2
ssrs 2008	1
standards	10
star schema	1
statistical calculations	1
statistical function	1
statistics	11
statistics io	2
statsstream	1
steps	1
storage	8
storage calculator	1
storage engine	2
storage internals	1
storage spaces	1
store	1
store procedure	1
stored procedure	1
stored procedures	3
strategies	1
strategy	2
streaminsight	3
stress	1
stress testing	2
string	2
sublatches	1
sudoku	1
superlatching	1
support	1
surface area	1
SUSPECT	1
switch	1
synchronous	1
system	1
system health	2
system heatlh	1
system stored procedures	1
system tables	1
system variables	1
system views	1
t-sql	31
t-sql code	2
table	2
table partitioning	1
table valued parameters	1
table variable	1
table variables	2
tables	1
tabular	1
tabular bi semantic model	3
tabular data model	1
tabular model	2
target recovery time	1
tde	2
technet	5
technical	2
technique	1
tecnical	1
temp table	2
tempdb	12
tempdb basics	1
temporary object	1
temporary table	1
temporary tables	1
terminology	1
test driven design	1
test environment	1
testing	4
TFS	1
threats	1
throughput	1
throw statement	1
time	1
time series	1
timeout	3
timestamps	1
tips	1
tips and tricks	10
tool	2
tools	10
TOP	1
top reasons	2
tpc-e	1
trace	3
trace flag	3
trace flag 5004	1
trace flags	1
tracing	1
tracking	1
tradeoffs	1
traffic data analysis	1
transaction	4
transaction isolations	1
transaction locks	1
transaction log	19
transaction log file	1
transaction log files	1
transactional database	1
transactional replication	2
transactions	2
transparent data encryption	3
trends	1
tricks	2
triggers	3
trim	1
trimming	1
troublehsooting	4
troubleshooting	55
troubleshooting kits	1
troubleshooting steps	1
truncate	1
truncation	1
truth	1
try-catch	1
tsql	1
tsqlt	3
tuning	23
tutorial	1
tvp	1
twitter	1
udf	2
undocumented	2
uniqueifiers	1
unit testing	1
unknown members	1
update statistics	2
updates	1
upgrade	6
upgrades	1
url	1
usage	3
user	1
user creation	1
user defined function	1
user operations	1
utilities	1
utility	1
utility queries	1
validation	1
values	1
values density	1
varchar	1
varchar(max)	1
vehicle identification number	1
version	1
version store	3
versioning	1
versions	1
vertipaq	3
very large tables	1
video	7
videos	2
views	3
vin	1
violation	1
virtual file stats	1
virtual lab	1
virtual launch event	1
visual studio	3
visual studio 2012	1
visual studio 2012 shell	1
visualization	3
vldb	1
VLF	2
vlf warnings	1
VMs	1
vs 2012	3
wait	1
wait stats	2
wait types	1
waits	1
warning	1
ways	1
webcasts	1
what-is-it	1
when-to-use	1
where	1
white paper	2
whitepaper	4
who is active	1
wiki	3
window	1
window function	1
window functionality	1
window functions	2
windows	2
windows 2008	2
windows 2008 r2	1
windows 8	1
windows azure	5
windows azure sql database	1
windows azure virtual machine	1
windows core	1
windows functions	1
windows server	1
windows server 2008	1
windows server 2008 r2	2
windows server 2012	2
with cache	1
WKT	1
workaround	1
workarounds	1
workbench	1
worker pool	1
workload	2
workload generator	1
worktables	1
writepage	1
writes	1
writing analysis	1
xel	1
XEvents	1
XML	4
XML file	1
xperf	1

Scooped by Shyam Viking onto My Love with SQL Server

Scoop.it!

From paultebraak.wordpress.com - July 10, 2012 5:32 AM

No comment yet.

Your new post is loading...

Scooped by Shyam Viking

Scoop.it!

From sqlblog.com - June 7, 8:10 AM

Shyam Viking's insight:

File Layout Viewer vs. Drop Clustered Index

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlperformance.com - June 7, 8:07 AM

Shyam Viking's insight:

Troubleshooting SQL Server CPU Performance Issues

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlskills.com - June 7, 7:42 AM

Shyam Viking's insight:

The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlskills.com - June 7, 4:31 AM

Shyam Viking's insight:

Inside the Storage Engine: Anatomy of a record

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.microsoft.com - May 22, 1:15 AM

Shyam Viking's insight:

Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Microsoft® Office®

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 17, 12:02 AM

Shyam Viking's insight:

SQL Server–Storage Spaces/VHDx and 4K Sector Size

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.technet.com - May 16, 4:55 AM

Shyam Viking's insight:

What is the estimate time for stopping an SQL Server Instance?

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 13, 5:56 AM

Shyam Viking's insight:

Sparse columns, An oblivious for any data/dimensional modeler !

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 10, 2:15 AM

Shyam Viking's insight:

Implications of the SQL Server Bulk Logged recovery model on point in time restores

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - April 29, 5:35 AM

Shyam Viking's insight:

True Black Box Recorder

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlskills.com - April 24, 3:19 AM

Shyam Viking's insight:

Documenting Availability Group PBM Conditions

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - April 23, 4:35 AM

Shyam Viking's insight:

Always On–When Is My Secondary Failover Ready?

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlskills.com - April 23, 3:09 AM

Shyam Viking's insight:

Reacting to XEvents in almost real-time

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlskills.com - June 7, 8:09 AM

Shyam Viking's insight:

The Accidental DBA (Day 2 of 30): Hardware Selection: Disk Configurations and RAID -> Performance not Capacity

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlperformance.com - June 7, 7:55 AM

Shyam Viking's insight:

Missing indexes? Watch your step when you are creating a missed one.

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From msdn.microsoft.com - June 7, 7:25 AM

Shyam Viking's insight:

Monitor Performance for AlwaysOn Availability Groups

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 27, 9:39 AM

Shyam Viking's insight:

How do I map a differential/transaction log backup to its full backup without using MSDB?

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blog.wharton.com.au - May 21, 1:56 AM

Shyam Viking's insight:

MCSM - New Certification Paths

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 17, 12:00 AM

Shyam Viking's insight:

Change Data Capture gets disabled when you break mirroring and bring the database online

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 16, 4:50 AM

Shyam Viking's insight:

Code Snippets in SQL Server 2012 For Greater Team Productivity

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From technet.microsoft.com - May 13, 5:25 AM

Shyam Viking's insight:

Service Broker: Performance and Scalability Techniques

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - May 2, 7:22 AM

Shyam Viking's insight:

Tracking down Deadlocks in SQL Database

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.sqlperformance.com - April 25, 7:28 AM

Shyam Viking's insight:

How filtered indexes could be a much more powerful feature

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From blogs.msdn.com - April 24, 1:32 AM

Shyam Viking's insight:

Identifying the cause of SQL Server IO bottlenecks using XPerf

No comment yet.

Scooped by Shyam Viking

Scoop.it!

From www.microsoft.com - April 23, 3:17 AM

Shyam Viking's insight:

Know how your data built around Windows Azure, SQL Server, SQL Azure can make your building "alive".

No comment yet.

My Love with SQL Server

File Layout Viewer vs. Drop Clustered Index

Troubleshooting SQL Server CPU Performance Issues

The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

Inside the Storage Engine: Anatomy of a record

Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Microsoft® Office®

SQL Server–Storage Spaces/VHDx and 4K Sector Size

What is the estimate time for stopping an SQL Server Instance?

Sparse columns, An oblivious for any data/dimensional modeler !

Implications of the SQL Server Bulk Logged recovery model on point in time restores

True Black Box Recorder

Documenting Availability Group PBM Conditions

Always On–When Is My Secondary Failover Ready?

Reacting to XEvents in almost real-time

The Accidental DBA (Day 2 of 30): Hardware Selection: Disk Configurations and RAID -> Performance not Capacity

Don’t just blindly create those “missing” indexes!

Monitor Performance for AlwaysOn Availability Groups

How do I map a differential/transaction log backup to its full backup without using MSDB?

MCSM - New Certification Paths

Change Data Capture gets disabled when you break mirroring and bring the database online

Code Snippets in SQL Server 2012 For Greater Team Productivity

Service Broker: Performance and Scalability Techniques

Tracking down Deadlocks in SQL Database

How filtered indexes could be a much more powerful feature

Identifying the cause of SQL Server IO bottlenecks using XPerf

88 Acres