Stack Exchange Network

Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Loading…
  1. 0
  2. +0
    • Tour Start here for a quick overview of the site
    • Help Center Detailed answers to any questions you might have
    • Meta Discuss the workings and policies of this site
    • About Us Learn more about Stack Overflow the company
    • Business Learn more about hiring developers or posting ads with us
  3. Log in Sign up
  4. current community

    • Database Administrators
      help chat
    • Database Administrators Meta

    your communities

    Sign up or log in to customize your list.

    more stack exchange communities

    company blog
Database Administrators
  1. Home
    1. Questions
    2. Tags
    3. Users
    4. Unanswered
    5. Jobs
Profile Activity
Meta user
Network profile
crokusek

Reputation

1,837
  • 1.8k
  • 1.5k
  • 1.2k
  • 2018
  • 2019
  • 2020
  • 2021

Next privilege

2,000 Rep.
Edit questions and answers

Badges

3
17
29

Newest

 Yearling

Next badge

26/30
Inquisitive

Impact

~315k
people reached
5 posts edited
0 helpful flags
128 votes cast
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

29 Questions

Votes Activity Newest Views
 
4
votes
1
answer
76
views

How to control Segmentation min/max data_id on a non-clustered ColumnStore index

sql-server columnstore sql-server-2019
Jun 3 at 21:03 crokusek 1,837
 
0
votes
0
answers
20
views

Why do tempdb spills still occur even with good row and data size estimates (better than actuals)?

tempdb cardinality-estimates
May 28 at 4:46 Niels Broertjes 415
1
7
votes
1
answer
810
views

How to get cross apply to operate row by row on a view?

sql-server execution-plan view cross-apply
Jan 26 '19 at 10:12 ypercubeᵀᴹ 88k
3
8
votes
1
answer
316
views

What cases benefit from the Reduce, Replicate, and Redistribute join hints?

sql-server join hints azure-sql-data-warehouse sql-server-pdw
Jun 12 at 6:01 Community♦ 1
1
1
vote
2
answers
132
views

Workaround to implement Minimum Degree of Parallelism

sql-server maxdop
Dec 11 '18 at 14:17 John K. N. 12.8k
 
3
votes
0
answers
74
views

Where is Newid(), Rand(), and Sysutcdatetime() new value per query vs. row behavior documented? [duplicate]

sql-server update insert
Aug 23 '18 at 11:27 ypercubeᵀᴹ 88k
1
4
votes
1
answer
2k
views

Read system_health event_file instead of ring_buffer for deadlocks extended events

sql-server sql-server-2012 deadlock xml extended-events
Aug 18 '17 at 17:39 crokusek 1,837
 
1
vote
0
answers
113
views

Schema transfer of SP does not update information_schema.routines.routine_definition / object_definition?

information-schema
Nov 8 '16 at 23:21 crokusek 1,837
 
5
votes
1
answer
8k
views

Querying True Physical Database File Sizes

sql-server database-size
Aug 14 '19 at 13:22 Aaron Bertrand 170k
2
8
votes
3
answers
353
views

How to improve estimate of 1 row in a View constrained by DateAdd() against an index

sql-server sql-server-2012 optimization view
May 18 '17 at 15:34 Paul White♦ 58.5k
 
7
votes
1
answer
367
views

Is it possible to get seek based parallel plan for distinct/group by?

sql-server index optimization group-by distinct
Sep 7 '15 at 12:45 Community♦ 1
 
1
vote
0
answers
684
views

What are recommended (working) permissions for a user to view all SQL Agent jobs

sql-server-2012 permissions sql-server-agent
Aug 23 '14 at 3:46 Community♦ 1
 
4
votes
1
answer
720
views

Why does Recursive CTE estimate just 1 row?

sql-server sql-server-2012 cte recursive cardinality-estimates
Sep 28 '15 at 12:01 Community♦ 1
3
10
votes
2
answers
2k
views

Is support for Parallel Scalar UDF a reasonable feature request?

sql-server parallelism functions
Nov 24 '19 at 15:07 Paul White♦ 58.5k
 
0
votes
1
answer
1k
views

Is is possible to handle a UserAbort or ClientTimeOut within a Stored Procedure?

sql-server transaction timeout
Jul 23 '14 at 19:40 Community♦ 1
1
6
votes
1
answer
435
views

Why is an additional filtered statistic being ignored (EAV schema)?

sql-server statistics eav cardinality-estimates
Aug 19 '15 at 1:33 Paul White♦ 58.5k
 
2
votes
2
answers
3k
views

How to improve row estimate of 1 row in join for newly inserted data

sql-server statistics optimization cardinality-estimates
May 7 '14 at 18:31 Community♦ 1
 
3
votes
1
answer
2k
views

Is it possible to raiserror within a For Delete Trigger that rolls back the deletes

sql-server trigger delete exception raiserror
Jan 30 '14 at 21:52 Community♦ 1
 
5
votes
1
answer
5k
views

Why does implicit conversion from sql_variant (basetype decimal) not work well with float

sql-server type-conversion cast sql-variant-property
Jan 14 '14 at 10:38 Martin Smith 75.1k
 
2
votes
1
answer
570
views

How to use proper hints for Upsert involving a top 1 subquery

sql-server locking deadlock upsert
Jan 10 '14 at 0:39 Community♦ 1
4
9
votes
2
answers
18k
views

How to clear an Error 15404 after a DB restart (besides rebooting)

sql-server sql-server-agent active-directory jobs
Nov 21 '17 at 14:11 Federico 1
 
1
vote
1
answer
735
views

How is parallelism threshold (seconds) used if query CPU cost is actually unitless

sql-server parallelism
Nov 20 '13 at 1:29 Community♦ 1
1
3
votes
0
answers
228
views

Why does removing a RID by creating a clustered index lose parallelism and slow down execution by 2X

sql-server performance clustered-index parallelism nonclustered-index
Oct 25 '13 at 19:25 crokusek 1,837
 
-4
votes
2
answers
2k
views

How to improve TempDb on RAMDisk showing performance on par with physical hard drive [closed]

sql-server optimization tempdb
Aug 5 '13 at 5:08 crokusek 1,837
2
11
votes
2
answers
10k
views

How can row estimates be improved in order to reduce chances of spills to tempdb

sql-server optimization join
Nov 7 '13 at 17:59 crokusek 1,837
 
3
votes
1
answer
910
views

How to determine cause of runtime increase given two query plans with SpillToTempDb warning

sql-server execution-plan tempdb
Apr 27 '13 at 12:13 Paul White♦ 58.5k
1
3
votes
1
answer
2k
views

Unable to run union in parallel on SQL Server

sql-server union
May 8 at 5:13 Aaron Bertrand 170k
2
10
votes
3
answers
20k
views

How to log error details when using using try/catch for dynamic SQL backup commands

sql-server backup error-handling
Feb 8 '17 at 19:01 Aaron Bertrand 170k
 
6
votes
2
answers
953
views

How to use merge hints to isolate complex queries in SQL Server

sql-server optimization join hints merge
Feb 10 '13 at 19:12 Community♦ 1
Database Administrators
  • Tour
  • Help
  • Chat
  • Contact
  • Feedback
  • Mobile
Company
  • Stack Overflow
  • For Teams
  • Advertise With Us
  • Hire a Developer
  • Developer Jobs
  • About
  • Press
  • Legal
  • Privacy Policy
  • Terms of Service
  • Cookie Settings
Stack Exchange
Network
  • Technology
  • Life / Arts
  • Culture / Recreation
  • Science
  • Other
  • Stack Overflow
  • Server Fault
  • Super User
  • Web Applications
  • Ask Ubuntu
  • Webmasters
  • Game Development
  • TeX - LaTeX
  • Software Engineering
  • Unix & Linux
  • Ask Different (Apple)
  • WordPress Development
  • Geographic Information Systems
  • Electrical Engineering
  • Android Enthusiasts
  • Information Security
  • Database Administrators
  • Drupal Answers
  • SharePoint
  • User Experience
  • Mathematica
  • Salesforce
  • ExpressionEngine® Answers
  • Stack Overflow em Português
  • Blender
  • Network Engineering
  • Cryptography
  • Code Review
  • Magento
  • Software Recommendations
  • Signal Processing
  • Emacs
  • Raspberry Pi
  • Stack Overflow на русском
  • Code Golf
  • Stack Overflow en español
  • Ethereum
  • Data Science
  • Arduino
  • Bitcoin
  • Software Quality Assurance & Testing
  • Sound Design
  • Windows Phone
  • more (28)
  • Photography
  • Science Fiction & Fantasy
  • Graphic Design
  • Movies & TV
  • Music: Practice & Theory
  • Worldbuilding
  • Video Production
  • Seasoned Advice (cooking)
  • Home Improvement
  • Personal Finance & Money
  • Academia
  • Law
  • Physical Fitness
  • Gardening & Landscaping
  • Parenting
  • more (10)
  • English Language & Usage
  • Skeptics
  • Mi Yodeya (Judaism)
  • Travel
  • Christianity
  • English Language Learners
  • Japanese Language
  • Chinese Language
  • French Language
  • German Language
  • Biblical Hermeneutics
  • History
  • Spanish Language
  • Islam
  • Русский язык
  • Russian Language
  • Arqade (gaming)
  • Bicycles
  • Role-playing Games
  • Anime & Manga
  • Puzzling
  • Motor Vehicle Maintenance & Repair
  • Board & Card Games
  • Bricks
  • Homebrewing
  • Martial Arts
  • The Great Outdoors
  • Poker
  • Chess
  • Sports
  • more (16)
  • MathOverflow
  • Mathematics
  • Cross Validated (stats)
  • Theoretical Computer Science
  • Physics
  • Chemistry
  • Biology
  • Computer Science
  • Philosophy
  • Linguistics
  • Psychology & Neuroscience
  • Computational Science
  • more (10)
  • Meta Stack Exchange
  • Stack Apps
  • API
  • Data
  • Blog
  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.1.20.38359

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.