Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 181406

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

1 vote
1 answer
67 views

Rebuild and Reorganize index while altering index

Can someone please explain for example if i have a unique non-clustered index on a table with 3 columns. due to some reason if i need to add one more column in the existing index . Do i need to rebu …
deep kachhawa's user avatar
1 vote
1 answer
289 views

Is there any way to find information of index fragmentation, Statistics information with the...

I am working on a report which will give information for different segments like blocking process slow running queries disk space etc. I also want to add one more segment where I can get informa …
deep kachhawa's user avatar
1 vote
1 answer
668 views

Directory Verification with For Each Loop in SSIS

How can we check if a directory is valid or not inside for each loop . I am having multiple files at some location and i want to load that file but before this i want to check if the directory is cor …
deep kachhawa's user avatar
0 votes
1 answer
16k views

Validation logic for Mobile Number Column in SQL Server

I am creating a validation script and need help with mobile number validation logic with below details. Mobile number must be: 10 digits in length. Cannot begin with a 1 or a 0 (For example:1144684 …
deep kachhawa's user avatar