| · BISQL # 1 :IT’s All About Primary Key and Basics of It !!! |
| · BISQL # 2 :How To Create Solution? Why and What is its Use!! |
| · BISQL # 3 :Time and Date Query code and Analysis Part -I |
| · BISQL # 4 :Identifying and Search of Relationship’s |
| · BISQL # 5 :Analyzing the Size of Database and Size of table |
| · BISQL # 6 :Identifying Running Query and Last Modified Query |
| · BISQL # 7 :ALL in One Database Hero Script !! Set–I |
| · BISQL # 8 : Pros and Cons of Money Data Type |
| · BISQL # 9 :How to Get Answers,Common Question :SQL Server FAQs eBook |
| · BISQL # 10 :Top 10 Things For SQL Server Performance Part – I |
| · BISQL # 12 :SQL Server Technical White Papers,All in one |
| · BISQL # 13 :Concept of Change Data Capture (CDC) in SQL Server 2008 Part –I |
| · BISQL # 14 :Concept of Change Data Capture (CDC) in SQL Server 2008 Part –II |
| · BISQL # 15 :Concept of Change Data Capture (CDC) in SQL Server 2008 Part –III |
| · BISQL # 16 :TO Get All File Details From local file into SQL Server |
| · BISQL # 17 :How to determine the version and edition of SQL Server |
| · BISQL # 18 :How to Backing up a Mirrored database using SQL Agent |
| · BISQL # 19 :How should we store Images and BLOB files in SQL Server |
| · BISQL # 20 :Why should I Learn SQL |
| · BISQL # 21 :All White Paper For SQL Server R2 Review and Better Understanding |
| · BISQL # 22 : Deep dive into GUID in SQL Server |
| · BISQL # 23 :SQL Server “Denali”: CTP3 now available !! |
| · BISQL # 24 :ALL Link Resource information for DB,.NET ,BI and Many More.. |
| · BISQL # 25 : Audit Trail Part : I- What is Audit Trailing ? |
| · BISQL # 26 : Audit Trail Part : II- Implementation of Auto Auditing with Pros,Cons |
| · BISQL # 27 : Audit Trail Part : III-Implementation of Audit Trailing with CDC |
| · BISQL # 28: Audit Trail Part : IV–Comparing Entity Framework and SQL CDC |
| · BISQL # 29 : Analysis and Documentation Query |
| · BISQL # 30 : How Should I Find Information about Data Type |
| · BISQL # 31 : How To Create Folder from SSMS |
| · BISQL # 32 : How To find Parent Child Relationship Between Tables |
| · BISQL # 33 : Lets Understand Stored Procedure |
| · BISQL # 34 : What is Identity IN SQL {Identity Part–I} |
| · BISQL # 35 : Deep dive into Identity Functions in SQL {Identity Part–II} |
| · BISQL # 36 : Queries to Understand more on Identity aspect {Identity Part–III} |
| · BISQL # 37 :Checking, Seeding and Reseeding of Identity {Identity Part–IV} |
| · BISQL # 38 : Introduction To Function – {SQL Server Function Part – I } |
| · BISQL # 39 : Details of Row set functions – {SQL Server Function Part – II} |
| · BISQL # 40 : SQL Server Code Name “Denali” CTP3 Product Guide |
| · BISQL # 41 : Difference Between Char And Varchar |
| · BISQL # 42 : How to find count of all the records in all the table |
| · BISQL # 43 : Introduction to DAC – Data-Tier Application {DAC Part – I} |
| · BISQL # 44 : DAC-Database Project Overview {DAC Part – II} |
| · BISQL # 45 : How to Rename .MDF File and .LDF file ? (i.e – .mdf , .ldf) |
| · BISQL # 46 : Information of SQL Server Database Services and Startup account |
| · BISQL # 47 : How to find Details of Any Column in Entire Database in One Query |
| · BISQL # 48 : How to Generate SELECT script for all tables in a Database |
| · BISQL # 49 : SQL Server Denali Feature # 1–FileTables #1 – Introduction,Theory |
| · BISQL # 50 : SQL Server Denali Feature # 1- FileTables # 2 – Demo , Scripting |
| · BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number |
| · BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !! |
| · BISQL # 52 : How To Check Database log file Details and Who Access last |
| · BISQL # 53 : SQL Server Denali Feature # 3 – AlwaysOn |
| · BISQL # 54 – SQL Server Execution Plan #1 – All Basics & Introduction to Execution Plan |
| · BISQL # 55 – Playing With Date type for getting Results as We Required |
| · BISQL # 56 – All SQL Server (T- SQL) Optimization Tips in Details with some example |
| · BISQL # 57 – How should I increase number of Recent File Option in SSMS plane ! |
| · BISQL # 58 – Useful SQL Command for SQL Server Database Development |
| · BISQL # 59 – SQL Server 2012 Developer Training Kit Web Installer Preview |
| · BISQL # 60 – How to Take Fast Script only for Stored Procedures from Data Base |
| · BISQL # 61 – How to analyze Views & Stored Procedures in Rapid Development ! |
| · BISQL # 62 – What are Statistics ?SSMS Statistics Information and Usage ,Reasons ! |
| · BISQL # 63 – How to get list of Object with its Owner information and Object type |
| · BISQL # 64 – How to Check for all running process and How to Kill running process |
| · BISQL # 65 – How to Find Column name by Data type in Database ? |
| · BISQL # 66 – SQL Server Denali Feature # 4 – Columnstore Indexes |
| · BISQL # 67 – SQL Server Denali Feature # 5–Security |
| · BISQL # 68 – How to Kill Process Very Fast , With Analysis and Efficiently |
| · BISQL # 69 – Laymen to SQL Developer # 1 – Introduction to brand New SQL Server |
| · BISQL # 70 – Laymen to SQL Developer # 2 – Assignment #1 – Part #1–Introduction |
| · BISQL # 71 – SQL Server 2012 #1– Download now – Release Candidate 0 !! Useful links |
| · BISQL # 72 – Laymen to SQL Developer # 3 – Assignment #1 – Part #2 – Why DBMS |
| · BISQL # 73 – How To find list of SQL Server Instances Installed on any machine |
| · BISQL # 74 – All SQL Query Related to Memory usage details for SQL Server instance |
| · BISQL # 75 – Laymen to SQL Developer # 4 – Assignment #1 – Part #3 – What is Data.. |
| · BISQL # 76 – Laymen to SQL Developer # 5 – Assignment #1 – Part #4 – What is Data.. |
| · BISQL # 77 – Laymen to SQL Developer # 6 – Assignment #1 – Part #5 – Schemes |
| · BISQL # 78 – How to Check All presents SQL Server Rights ,Permission and Right |
| · BISQL # 79 – SQL Server Global Variable #1–Introduction Global Variable with detailed |
| · BISQL # 80 – SQL Server Global Variable #2 – Global Variable 12 of 36 |
| · BISQL # 81 – SQL Server Global Variable #3 – Global Variable 24 of 36 |
| · BISQL # 82 – SQL Server Global Variable #4 – Global Variable 36 of 36 |
| · BISQL # 83 – Laymen to SQL Developer # 7 – Assignment #1 – Part #6 – Storage manager, Query Processing ,Transaction Management and Internals |
| · BISQL # 84 – How to select ALL tables or Select all Top rows in one script . |
| · BISQL # 85 – SQL SERVER – Interview Questions and Answers Book |
| · BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell |
| · BISQL # 87 – Why DB Diagram doesn’t Work !! OR How to enable Database Diagram |
| · BISQL # 88 – Laymen to SQL Developer # 8 – Assignment #1 – Part #7 – Explanation and Basic Theory for Codd’s Rules and Normalization |
| · BISQL # 89 – How to establish / Find relationship between Table and stored Procedure |
| · List of Monthly post of MS BI, SQL & Link Resource Blog – March 2012 |
| · BISQL # 90 – How to find Number of lines of Code in procedure or function |
| · BISQL # 91 – How to alter Similar column Or Alter All column in one Query in DB |
| · BISQL # 92 – How to find Number of lines of Code in Database |
| · BISQL # 93 – How to find list of Stored procedure which does not depend on any table |
| · BISQL # 94 – How to find tables which is not participating in SP table relationship |
| · BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server |
| · BISQL #96 – SQL Server 2012 – Restore Database Features and Simplicity |
| · BISQL #97 – Laymen to SQL Developer # 9 – Assignment #2 – Relational Model, Schema, Attribute, Database, Key & Relational Query |
| · BISQL # 98 – Introduction of Private Cloud with SQL Server and Hyper-V, Resource Link |
| · BISQL # 99 – ‘A to Z’ SQL Command # 1 – List of Command which are present in SQL Server 2008 R2 AND SQL Server 2012 |
| · Starting of Brand New Series – ‘A to Z’ SQL Command Series |
| · List of Monthly post of MS BI,SQL & Link Blog – May 2012 |
| · Security Guide for SAP on SQL Server 2012 – Whitepaper Released |
| · Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !! |
| · Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012 |
| · New Features , SSDT Introduction and links |
| · Installation, Problem, Support and Help ! |
| · Migrating to SQL Server 2012 Failover Clustering and Availability Groups |
| · SQL Server Team – SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available–Updates and Downloads |
| · 100 Download in 5 Days – SQL PraRup – Free Tool for Formatting/Indenting SQL Server |
| · BISQL # 103 : ‘A to Z’ SQL Command with Syntax, Description, Usage and Example # 2 : ALTER USER |
| · BISQL # 104 : ‘A to Z’ SQL Command with Syntax, Description, Usage and Example # 3 : Checkpoints |
| · Microsoft Press : Free eBook: Introducing Windows Server 2012 |
| · List of Monthly post of MS BI,SQL & Link Blog : July 2012 |
| · BISQL # 105 : SQL Server 2012 : Resource Governor : Introduction, Syntax, Example, Resources and Explanation with SQL Server 2012 Enhancement |
| · BISQL # 106 : SQL Server 2012 : CONCAT() function : Introduction, Syntax, Example and Queries |
| · Year 2012 – Thanks , Review Stats, Summaries and Some Memories and Good Bye ! |
| · BISQL # 107 : Guest Post : Index Best Practices By: Mohammad Shahed |
| · BI SQL # 108 : Restarting Blogging in SQL Domain – Back Log and Future blog post and Series information ! |
| · SQL Server Spirit With Community Badges ! fun ! Updates to About Me page ! |
| · BI SQL # 109 : Information on SQL Server 2012 Licensing Core-based and Server/CAL Models |
| · BI SQL # 110 : SQL Server Script : Drop Database script without getting affected by any running queries on same Database |
| · Database Objects |
| · Launching SQL PraRup – Free Tool for Formatting SQL Server Database Objects |
| · Lunching INFOGRAPHICS Mentalist – New face of knowledge sharing –New Blog , Under Mentalist Hood , Image worth explaining 100’s of Words ! |
| · BI SQL # 111 : SQL Server Script : Optimization : Find top N heavy and time consuming SQL operation at runtime at any time |
| · BI SQL # 112 : SQL Server DBA Scripts : Generate Script for ALL index for Given Database |
| · BI SQL # 113 : SQL Server DBA Scripts : Display Table, Index Name , Key Cols and list of included columns |
| · BI SQL # 114 : SQL Server DBA Scripts : Find all nested stored procedure – Stored procedure called in another procedure |
| · BI SQL # 115 : SQL Server DBA Scripts : Simply find DB Size in MB and GB |
| · BI SQL # 116 : SQL Server DBA Scripts : Find All Database table relation in 1-* format |
| · BI SQL # 117 : SQL Server DBA Scripts : Find restored Date and Back up Date with Source file details |
| · BI SQL # 118 : SQL Server DBA Scripts : Find out the stored procedure which contain the selected Column name |
| · BI SQL # 119 : SQL Server DBA Scripts : Get the total Rows, Reserved Space, Data, Index Size, and Unused Space of Table |
| · BI SQL # 120 : SQL Server DBA Scripts : How to Verify Backup before restoring it ! |
| · BI SQL # 121 : SQL Server DBA Scripts : Script to identify tables without Primary Key |
| · BI SQL # 122 : SQL Server DBA Scripts : Script to backup all Database in SQL Server |
| · BI SQL # 123 : SQL Server DBA Scripts : Re-Indexing Script at Database Level |
| · BI SQL # 124 : SQL Server DBA Scripts : SQL Command to find the free space and used space of each file of a specific database!! |
| · BI SQL # 125 : SQL Server DBA Scripts : SQL Script to find the List of blocked processes and time blocked for each blocking process! |
| · BI SQL # 126 : SQL Server DBA Scripts : Space utilization in terms of Driver Space |
| · BI SQL # 127 : SQL Server DBA Scripts : To find all the log files and the percentage space used of those log files in an instance! |
| · BI SQL # 128 : SQL Server DBA Scripts : To list the files(.mdf and .ndf) and their details in a particular database! |
| · BI SQL # 129 : SQL Server DBA Scripts : SQL SP to find the details about locks currently held by the processes |
| · TechEd Europe Announcement : SQL Server 2014 – Public CTP Now Available ! Download , Learn & Share |
| · BI SQL # 130 : SQL Server DBA Scripts : SQL DBCC command to check the open transactions! |
| · BI SQL # 131 : SQL Server DBA Scripts : SQL Script to find MS SQL Server product level details! |
| · BI SQL # 132 : SQL Server DBA Scripts : Report Login Failures |
| · BI SQL # 133 : SQL Server DBA Scripts : Cumulative IO Stats |
| · BI SQL # 134 : SQL Server DBA Scripts : Display Session request and Internal allocation |
| · BI SQL # 135 : SQL Server DBA Scripts : Display Table With Row page per count |
| · BI SQL # 136 : SQL Server DBA Scripts : Find Circular reference in given Database |
| · BISQL – Laymen to SQL Developer # 10 – DBMS [Database Management System] #1 – Introduction, Database Environment, Working of a Simple Centralized Database System |
| · BI SQL # 137 : SQL Server DBA Scripts : Copy data from one database to another |
| · BI SQL # 138 : SQL Server DBA Scripts : Current processes and their SQL statements |
| · BI SQL # 139 : SQL Server DBA Scripts : Current SSRS Sessions |
| · BI SQL # 140 : SQL Server DBA Scripts : Database size growth as a pivot table |
| · BI SQL # 141 : SQL Server DBA Scripts : Database Space usage in detail |
| · BI SQL # 142 : SQL Server DBA Scripts : Databases Processes Overview |
| · BI SQL # 143 : SQL Server DBA Scripts : High CXPacket Wait counts in an OLTP environment |
| · BI SQL # 144 : SQL Server DBA Scripts : State of the databases with the command DBCC CHECKDB |
| · BI SQL # 145 : SQL Server DBA Scripts : Defrag all indexes within a database |
| · BI SQL # 146 : SQL Server DBA Scripts : Delete duplicates from any table |
| · BI SQL # 147 : SQL Server DBA Scripts : Delete rows from relational tables with foreign keys |
| · BI SQL # 148 : SQL Server DBA Scripts : Delta IO Stats |
| · I am presenting @ Navi Mumbai User Group Event on Microsoft Technologies in Surya InfoEdge on SQL Server 2014 & MS BI |
| · BI SQL # 149 : SQL Server DBA Scripts : Detailed list of all tables and their size |
| · BI SQL # 150 : SQL Server DBA Scripts : Detailed Table and Index Breakdown information |
| · BI SQL # 151 : SQL Server DBA Scripts : Detailed Table and Index Breakdown With Buffered |
| · BI SQL # 152 : SQL Server DBA Scripts : Determine last database backups |
| · BI SQL # 153 : SQL Server DBA Scripts : File sizes per type for all databases |
| · BI SQL # 154 : SQL Server DBA Scripts : Find columns by properties |
| · BI SQL # 155 : SQL Server DBA Scripts : Foreign Keys Overview |
| · BI SQL # 156 : SQL Server DBA Scripts : Get List of Linked Servers and associated logins |
| · BI SQL # 157 : SQL Server DBA Scripts : Get database file space usage for all Database |
| · BI SQL # 158 : SQL Server DBA Scripts : How many Objects exists in a Schema |
| · BI SQL # 159 : SQL Server DBA Scripts : List of all to Get SSRS Usage Report |
| · BI SQL # 160 : SQL Server DBA Scripts : Get the status of the SQL Server jobs |
| · New Announcement : NMUG now Chapter of with SQL PASS |
| · BI SQL # 161 : SQL Server DBA Scripts : How to find the SQL Server Running Jobs Time Elapsed status |
| · BI SQL # 162 : SQL Server DBA Scripts : How to get information from Change Data Capture (CDC) Tables |
| · BI SQL # 163 : SQL Server DBA Scripts : List of all check constraints |
| · BI SQL # 164 : SQL Server DBA Scripts : List all Database Permissions |
| · BI SQL # 164 : SQL Server DBA Scripts : List all Database Permissions |
| · BI SQL # 165 : SQL Server DBA Scripts : List all heap tables |
| · BI SQL # 166 : SQL Server DBA Scripts : List all indexed Views |
| · BI SQL # 167 : SQL Server DBA Scripts : List all Locks of the Current Database |
| · BI SQL # 168 : SQL Server DBA Scripts : List all Objects and Indexes per Filegroup or Partition |
| · BI SQL # 169 : SQL Server DBA Scripts : List all Server Permissions |
| · BI SQL # 170 : SQL Server DBA Scripts : List all SSIS packages stored in msdb database |
| · BI SQL # 171 : SQL Server DBA Scripts : List all SSRS report parameters with definition |
| · BI SQL # 172 : SQL Server DBA Scripts : List all SSRS subscriptions |
| · BI SQL # 173 : SQL Server DBA Scripts : List all trigger with SQL definition |
| · BI SQL # 174 : SQL Server DBA Scripts : List connection strings of all SSRS Shared Data sources |
| · BI SQL # 175 : SQL Server DBA Scripts : List Database Roles and Members with Server Login |
| · BI SQL # 176 : SQL Server DBA Scripts : List for all SSRS reports that use data sources and datasets with the command text |
| · BI SQL # 177 : SQL Server DBA Scripts : List expensive queries CHILD |
| · BI SQL # 178 : SQL Server DBA Scripts : List expensive queries MAIN |
| · BI SQL # 179 : SQL Server DBA Scripts : Log Growth Rate |
| · BI SQL # 180 : SQL Server DBA Scripts : List log file information for all the databases on the server |
| · BI SQL # 181 : SQL Server DBA Scripts : Overview of Locks per Database and Type |
| · BI SQL # 182 : SQL Server DBA Scripts : Page Life Expectancy |
| · BI SQL # 183 : SQL Server DBA Scripts : Pages per object in buffer pool |
| · BI SQL # 184 : SQL Server DBA Scripts : Pending IO Requests |
| · BI SQL # 185 : SQL Server DBA Scripts : Programmability Objects and their Parameters |
| · BI SQL # 186 : SQL Server DBA Scripts : Find the details of the given report name by querying Report Server Database |
| · BI SQL # 187 : SQL Server DBA Scripts : Query Master Data with Details as Comma Separated Value |
| · BI SQL # 189 : SQL Server DBA Scripts : Run DBCC CHECKDB on all databases |
| · BI SQL # 190 : SQL Server DBA Scripts : Script to find the partition key of a table |
| · BI SQL # 191 : SQL Server DBA Scripts : Search for a string in all tables of SQL Server Database |
| · BI SQL # 192 : SQL Server DBA Scripts : Search string or pattern in SQL module definition |
| · BI SQL # 195 : SQL Server DBA Scripts : SQL Server replication publication information |
| · BI SQL # 196 : SQL Server DBA Scripts : Script to VLF count for all databases |
| · BI SQL # 197 : SQL Server DBA Scripts : Overview of all objects created in SSRS ordered by the folder hierarchy |
| · BI SQL # 197 : SQL Server DBA Scripts : Overview of all objects created in SSRS ordered by the folder hierarchy |
| · BI SQL # 198 : SQL Server DBA Scripts : Stored procedure Execution statistics |
| · BI SQL # 199 : SQL Server DBA Scripts : Temporary Tables and Their Size |
| · BI SQL # 200 : SQL Server DBA Scripts : Various SQL Server IO Statistics |
| · BI SQL # 201 : SQL Server DBA Scripts : Job Failure Notification |
| · BI SQL # 202 : SQL Server DBA Scripts : How to Delete Database through Script |
| · BI SQL # 203 : SQL Server DBA Scripts : Identify Top Nth heavy I / O Operation |
| · BI SQL # 204 : SQL Server DBA Scripts : Identify Top Nth waits With I / O Specification |
| · BI SQL # 205 : SQL Server DBA Scripts : Identify High Latch Waits |
| · BI SQL # 206 : SQL Server DBA Scripts : Identify IO Stall For Each DB |
| · BI SQL # 207 : SQL Server DBA Scripts : Identify Free space in Temp DB |
| · BI SQL # 208 : SQL Server DBA Scripts : Identifying Procedures Taking More Execution time |
| · BI SQL # 209 : SQL Server DBA Scripts : Displaying Table Name Having Primary Key with Column Name |
| · BI SQL # 210 : SQL Server DBA Scripts : Reset Identity Column |
| · BI SQL # 211 : SQL Server DBA Scripts : How to Drop All Table from database through Script |
| · BI SQL # 212 : SQL Server DBA Scripts : Searching String in Steps of JOB |
| · BI SQL # 213 : SQL Server DBA Scripts : Reads and Writes in Database |
| · BI SQL # 214 : SQL Server DBA Scripts : Identify Number of Lines of code for each database Object |
| · BI SQL # 215 : SQL Server DBA Scripts : Making IDENTITY column to NON-IDENTITY & vice versa |
| · BI SQL # 216 : SQL Server DBA Scripts : Searching For Specific column for all Tables in database |
| · BI SQL # 217 : SQL Server DBA Scripts : Display Configuration Settings |
| · BI SQL # 218 : SQL Server DBA Scripts : Identify size of all non clustered indexes |
| · BI SQL # 219 : SQL Server DBA Scripts : Add mdf file as new DB |
| · BI SQL # 220 : SQL Server DBA Scripts : Find Any Column with Specific DataType |
| · BI SQL # 221 : SQL Server DBA Scripts : Find Specific text in database |
| · BI SQL # 222 : SQL Server DBA Scripts : Find Tables without Primary Key |
| · BI SQL # 223 : SQL Server DBA Scripts : Get All table Size Information |
| · BI SQL # 224 : SQL Server DBA Scripts : Display Memory Configuration |
| · BI SQL # 225 : SQL Server DBA Scripts : Display Space Details for Given database |
| · BI SQL # 226 : SQL Server DBA Scripts : Display Name And Size of Drive on Machine |
| · BI SQL # 227 : SQL Server DBA Scripts : Display Table info with Index and Rows |
| · BI SQL # 228 : SQL Server DBA Scripts : Create Alter Script Dynamically |
| · BI SQL # 229 : SQL Server DBA Scripts : Enable Data Compression |
| · BI SQL # 230 : SQL Server DBA Scripts : Disable Data Compression |
| · BI SQL # 231 : SQL Server DBA Scripts : Create Primary Key for all Tables |
| · BI SQL # 232 : SQL Server DBA Scripts : Backup Old And Restore new Database through Script |
| · BI SQL # 233 : SQL Server DBA Scripts : Trim all column of given table |
| · BI SQL # 234 : SQL Server DBA Scripts : Get Distinct Value for each column from Table |
| · BI SQL # 235 : SQL Server DBA Scripts : Identify Structure of a Table |
| · BI SQL # 236 : SQL Server DBA Scripts : Find list of stored procedure with content info |
| · BI SQL # 237 : SQL Server DBA Scripts : A. Compare Database |
| · BI SQL # 238 : SQL Server DBA Scripts : B. Compare Database |
| · BI SQL # 239 : SQL Server DBA Scripts : C. Compare Database |
| · BI SQL # 240 : SQL Server DBA Scripts : Foreign Key & Primary Key Relationship All |
| · BI SQL # 241 : SQL Server DBA Scripts : Find SQL Server Service Account |
| · BI SQL # 242 : SQL Server DBA Scripts : Shrink Log file through Script |
| · BI SQL # 243 : SQL Server DBA Scripts : Finding all the objects that have been modified in the last N days in database |
| · BI SQL # 244 : SQL Server DBA Scripts : Restore Database Through script |
| · BI SQL # 245 : SQL Server DBA Scripts : Show Running Queries on SSMS |
| · BI SQL # 246 : SQL Server DBA Scripts : SQL DMV to find the details of current processes running like percent completed!! |
| · BI SQL # 247 : SQL Server DBA Scripts : List all the Databases on Server |
| · BI SQL # 248 : SQL Server DBA Scripts : Find Tables with Foreign Key Constraint in Database |
| · BI SQL # 249 : SQL Server DBA Scripts : Finding tempdb Size and Growth Parameters |
| · BI SQL # 250 : SQL Server DBA Scripts : List all roles of the current database with their members |
| · BI SQL # 251 : SQL Server DBA Scripts : List SQL Script to find the Roles assigned to the SQL Logins including Create_data and modify_date |
| · BI SQL # 252 : SQL Server DBA Scripts : Find SQL Server Start time and End time |
| · BI SQL # 253 : SQL Server DBA Scripts : Permissions Script |
| · BI SQL # 254 : SQL Server DBA Scripts : Estimating Rows per Page |
| · BI SQL # 255 : SQL Server DBA Scripts : Find Recently Executed Stored Procedures |
| · BI SQL # 256 : SQL Server DBA Scripts : Check VLF Counts in Database |
| · BI SQL # 257 : SQL Server DBA Scripts : SQL Agent Job Script |
| · BI SQL # 258 : SQL Server DBA Scripts : Index Definition Audit Script |
| · BI SQL # 259 : SQL Server DBA Scripts : Database current size, auto growth setting and file location |
| · BI SQL # 260 : SQL Server DBA Scripts : Find last backup details of all databases in a server |
| · BI SQL # 261 : SQL Server DBA Scripts : Find If any database is Offline |
| · BI SQL # 262 : SQL Server DBA Scripts : Find IP Address of machine |
| · BI SQL # 263 : SQL Server DBA Scripts : All Database Information |
| · BI SQL # 264 : SQL Server DBA Scripts : Monitoring Database Backups |
| · BI SQL # 265 : SQL Server DBA Scripts : Compare Data Table |
| · BI SQL # 266 : SQL Server DBA Scripts : Find Cumulative IO Stats |
| · BI SQL # 267 : SQL Server DBA Scripts : Identity Columns: Are You Nearing The Limits? |
| · BI SQL # 268 : SQL Server DBA Scripts : Find Statistics Info for all tables |
| · BI SQL # 269 : SQL Server DBA Scripts : Find all server running in n/w |
| · BI SQL # 270 : SQL Server DBA Scripts : Find the SQL Server Protocols Status |
| · BI SQL # 271 : SQL Server DBA Scripts : Display all Server Information |
| · BI SQL # 272 : SQL Server DBA Scripts : Find Connectivity information |
| · BI SQL # 273 : SQL Server DBA Scripts : Core in server |
| · BI SQL # 274 : SQL Server DBA Scripts : Space used by version store |
| · BI SQL # 275 : SQL Server DBA Scripts : Find Session details |
| · BI SQL # 276 : SQL Server DBA Scripts : Find all DB IO with Rank |
| · BI SQL # 277 : SQL Server DBA Scripts : Find TOP IO Stored Procedure |
| · BI SQL # 278 : SQL Server DBA Scripts : How to Quick Search Anything in Database in SQL Server |
![image_thumb[1]](http://bimentalist.files.wordpress.com/2011/12/image_thumb113.png "image_thumb[1]")
SQL Server Mentalist 