| 411 |
Aug 23, 2020 |
SQL Server 2019 -Verbose Truncation Warnings |
| 410 |
Jun 23, 2016 |
SQL SERVER 2016 – TSQL Enhancements – DROP IF EXISTS |
| 409 |
Dec 31, 2015 |
2015 in review |
| 408 |
Sep 10, 2015 |
SQL SERVER – sp_refreshsqlmodule – How to update the metadata of an object |
| 407 |
Sep 4, 2015 |
SQL SERVER – Fix – Error – 11553 – EXECUTE statement failed because its WITH RESULT SETS clause specified a non-nullable type for column #%d in result set #%d |
| 406 |
Aug 29, 2015 |
SQL Server – Resource Governor- How to control physical IO |
| 405 |
Aug 22, 2015 |
SQL SERVER – How to split one column into multiple columns |
| 404 |
Aug 21, 2015 |
SQL SERVER – How to implement conditional order by clause |
| 403 |
Jul 30, 2015 |
SQL SERVER – Fix – Error : 262- SHOWPLAN permission denied in database |
| 402 |
Jun 29, 2015 |
SQL SERVER 2016 – Temporal Tables |
| 401 |
Jun 23, 2015 |
SQL SERVER 2016 – TSQL Enhancements – Truncate Table |
| 400 |
Jun 20, 2015 |
SQL SERVER 2016 – Row Level Security (RLS) |
| 399 |
Jun 9, 2015 |
SQL SERVER – How to identify delayed durabilty is disabled using Policy Based Management |
| 398 |
May 31, 2015 |
SQL SERVER – How to determine who dropped Database at what time ? |
| 397 |
May 31, 2015 |
SQL SERVER – How to find the status of backup / restore using T-SQL |
| 396 |
May 27, 2015 |
Raresql News – Introduction to Policy Based Management at SQL Server User Group, Dubai, UAE – May 26, 2015 |
| 395 |
Apr 15, 2015 |
SQL SERVER – Fix – Error :195 – ‘TRY_CONVERT’ is not a recognized built-in function name |
| 394 |
Mar 31, 2015 |
SQL SERVER – SET NOEXEC |
| 393 |
Mar 30, 2015 |
SQL SERVER – How to get total row count from OFFSET / FETCH NEXT (Paging) |
| 392 |
Mar 25, 2015 |
Raresql News – Extended Events at SQL Server User Group, Dubai, UAE – March 24, 2015 |
| 391 |
Jan 16, 2015 |
SQL SERVER – How to create a nonclustered index within the create table statement |
| 390 |
Jan 14, 2015 |
SQL Server – How to convert hexadecimal to binary |
| 389 |
Jan 13, 2015 |
SQL SERVER – How to connect Azure SQL Server using SQL Server Management Studio (SSMS) |
| 388 |
Jan 9, 2015 |
AZURE SQL SERVER – How to create server and database |
| 387 |
Jan 5, 2015 |
SQL SERVER – How to remove the duplicate words in the sentence |
| 386 |
Dec 31, 2014 |
SQL SERVER 2014 – How to RESTORE backup from URL (Windows Azure Storage) – PowerShell |
| 385 |
Dec 30, 2014 |
SQL SERVER 2014 – How to take backup to URL (Windows Azure Storage) – SSMS |
| 384 |
Dec 30, 2014 |
2014 in review |
| 383 |
Dec 28, 2014 |
SQL SERVER 2014 – How to RESTORE backup from URL (Windows Azure Storage) – TSQL |
| 382 |
Dec 27, 2014 |
SQL SERVER 2014 – How to take backup to URL (Windows Azure Storage) – PowerShell |
| 381 |
Dec 26, 2014 |
SQL SERVER 2014 – How to take backup to URL (Windows Azure Storage) – SSMS |
| 380 |
Dec 6, 2014 |
SQL SERVER 2014 – How to take backup to URL (Windows Azure Storage) – TSQL |
| 379 |
Dec 5, 2014 |
Microsoft Azure – How to create storage and container |
| 378 |
Nov 30,2014 |
SQL SERVER – Find Largest Table in Database – WITHOUT T-SQL |
| 377 |
Nov 25,2014 |
Raresql News – SQL Server Community Meet up |
| 376 |
July 14,2014 |
SQL SERVER – How to convert yyyymm to Mon-yyyy |
| 375 |
July 11,2014 |
SQL SERVER – How to convert Select statement result set into Insert statements |
| 374 |
July 6, 2014 |
SQL SERVER 2012 – Fix – Error :22939 – The parameter @supports_net_changes is set to 1. |
| 373 |
July 4, 2014 |
SQL SERVER – How to setup Database mail using FREE mail accounts |
| 372 |
June 29, 2014 |
SQL SERVER – How to delete recent connection from Connect to Server window in SSMS |
| 371 |
June 28, 2014 |
SQL SERVER – Sending mail when a procedure has been executed |
| 370 |
June 15, 2014 |
SQL SERVER – How to refresh all views related to modified tables |
| 369 |
May 30, 2014 |
SQL SERVER – How to create a Sub Directory in FileTable using TSQL |
| 368 |
May 12, 2014 |
SQL SERVER 2012 – Fix – Error : 22960- Change data capture instance has not been enabled for the source table |
| 367 |
May 5, 2014 |
SQL SERVER – Working with Change Data Capture – Part 4 |
| 366 |
May 4, 2014 |
SQL SERVER – Working with Change Data Capture – Part 3 |
| 365 |
April 29, 2014 |
SQL SERVER – Working with Change Data Capture – Part 2 |
| 364 |
April 14, 2014 |
SQL SERVER – Working with Change Data Capture – Part 1 |
| 363 |
April 11, 2014 |
SQL SERVER – Fix – Issue – How to enable Explore FileTable Directory in a FileTable |
| 362 |
April 8, 2014 |
SQL SERVER – Upgrading to SQL Server 2012 from SQL 2005/2008 – Part 1 |
| 361 |
April 1, 2014 |
SQL SERVER – How to kill all running processes |
| 360 |
March 30, 2014 |
SQL SERVER – How to create a Columnstore index in a Partitioned table |
| 359 |
March 22, 2014 |
SQL SERVER 2012 – Full-Text Search – Custom proximity search with NEAR |
| 358 |
March 21, 2014 |
SQL SERVER – Fix – Error – Unable to install SQL Server 2012 Upgrade Advisor |
| 357 |
March 20, 2014 |
SQL SERVER – How to Identify the Locks Held by FileTables |
| 356 |
March 19, 2014 |
SQL SERVER – How to delete old backup files automatically |
| 355 |
March 17, 2014 |
SQL SERVER 2012 – How to generate a negative serial numbers for a result set by using the Sequence Object |
| 354 |
March 16, 2014 |
SQL SERVER – How to alter an existing computed column in a table |
| 353 |
March 12, 2014 |
SQL SERVER – How to find missing (mismatch) rows across result sets |
| 352 |
March 11, 2014 |
SQL SERVER – Fix – Error – 22830 – Could not update the metadata that indicates database %s is enabled for Change Data Capture |
| 351 |
March 10, 2014 |
SQL SERVER 2012 – How to drop default constraint related to Sequence object |
| 350 |
February 26, 2014 |
SQL SERVER – Who dropped what object at what time ? |
| 349 |
February 25, 2014 |
SQL SERVER – sp_refreshview – How to update the metadata of view |
| 348 |
February 24, 2014 |
SQL SERVER – Toggle between completion mode and suggestion mode |
| 347 |
February 21, 2014 |
SQL SERVER – Fix – Error – The File location cannot be opened. Either access is not enabled or you do not have permissions for the same. |
| 346 |
February 20, 2014 |
SQL SERVER – How to schedule automated back up |
| 345 |
February 18, 2014 |
SQL SERVER – How to read the metadata of backup files |
| 344 |
February 16, 2014 |
SQL SERVER – Multiple ways to find all the tables that do not have a primary key? |
| 343 |
February 15, 2014 |
SQL SERVER – How to create a folder (directory) inside FileTable |
| 342 |
February 12, 2014 |
SQL SERVER – Fix – Error – 3023 – Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. |
| 341 |
February 11, 2014 |
SQL SERVER – How to filter databases in sp_MSforeachdb |
| 340 |
February 9, 2014 |
SQL SERVER – Why my result set gives me constant number of rows ? (SET ROWCOUNT) |
| 339 |
February 7, 2014 |
SQL SERVER – How to Refresh SSMS IntelliSence Local Cache |
| 338 |
February 4, 2014 |
SQL SERVER – Multiple ways to convert Datetime to Varchar |
| 337 |
January 29, 2014 |
SQL SERVER – Fix – Error : 529- Explicit conversion from data type %ls to %ls is not allowed |
| 336 |
January 27, 2014 |
SQL SERVER – Why cannot I take the Transaction Log backup |
| 335 |
January 24, 2014 |
SQL SERVER – Standard Reports |
| 334 |
January 20, 2014 |
SQL SERVER – How to remove leading zeros after a decimal point |
| 333 |
January 19, 2014 |
SQL SERVER – Fix – Error – 15281 – SQL Server blocked access to %S_MSG ‘%ls’ of component ‘%.*ls’ because this component is turned off as part of the security configuration for this server |
| 332 |
January 18, 2014 |
SQL SERVER – How to retrieve the metadata of a stored procedure |
| 331 |
January 17, 2014 |
SQL SERVER – How to return ’0′ instead of NULL in a query resultset |
| 330 |
January 15, 2014 |
SQL SERVER – APEXSQL Diff – Schema comparison tool (25% Discount!) |
| 329 |
January 13, 2014 |
SQL SERVER – Multiple ways to view the definition of a module |
| 328 |
January 10, 2014 |
SQL SERVER 2012 – Fix – Error :11526 – The metadata could not be determined because statement ‘%.*ls’ in procedure ‘%.*ls’ uses a temp table. |
| 327 |
January 7, 2014 |
SQL SERVER – How to get first Sunday of next month using EOMONTH |
| 326 |
January 5, 2014 |
SQL SERVER – How to get the list of all triggers using sp_MSforeachtable |
| 325 |
January 3, 2014 |
SQL SERVER – A quick solution to ‘String or binary data would be truncated’ using Stored procedure |
| 324 |
January 1, 2014 |
SQL SERVER – dm_db_log_space_usage – dynamic management view |
| 323 |
December 31, 2013 |
SQL SERVER 2012 – Fix – Error : 41209 – A semantic language statistics database is not registered. Full-text indexes using ‘STATISTICAL_SEMANTICS’ cannot be created or populated |
| 322 |
December 30, 2013 |
SQL SERVER – How to check if data has carriage return and line feed? |
| 321 |
December 29, 2013 |
SQL SERVER 2012 – Generating serial numbers for a result set by using sequence object |
| 320 |
December 28, 2013 |
SQL SERVER – Virtual Labs |
| 319 |
December 26, 2013 |
SQL SERVER – How to insert & view multiline text in any varchar field |
| 318 |
December 24, 2013 |
SQL SERVER – How to recover the accidentally renamed object name |
| 317 |
December 22, 2013 |
SQL SERVER – Fix – Error – 10920 – Cannot %S_MSG user-defined function ‘%.*ls’. It is being used as a resource governor classifier |
| 316 |
December 16, 2013 |
SQL SERVER – How to get only the numbers after the decimal? |
| 315 |
December 11, 2013 |
SQL SERVER – How to use a temp table in a table-valued function |
| 314 |
December 10, 2013 |
SQL SERVER – How to select minimum value from group in a table |
| 313 |
December 7, 2013 |
SQL SERVER – How to filter tables in sp_MSforeachtable |
| 312 |
December 6, 2013 |
SQL SERVER – Fix – Error – 1011 – The correlation name ‘%.*ls’ is specified multiple times in a FROM clause |
| 311 |
December 1, 2013 |
SQL SERVER 2012 – How to check last modified date in Sequence |
| 310 |
November 28, 2013 |
SQL Server – How to trim all columns in a table |
| 309 |
November 25, 2013 |
SQL SERVER – Mathematical Functions – LOG |
| 308 |
November 22, 2013 |
SQL SERVER 2012 – How to make Sequence as default value for a column in a table |
| 307 |
November 19, 2013 |
SQL SERVER 2012 – Fix – Error – 5591 – FILESTREAM feature is disabled |
| 306 |
November 18, 2013 |
SQL SERVER – How to use ISDATE with datetime2 datatype |
| 305 |
November 16, 2013 |
SQL SERVER – Multiple ways to remove the last character in a string |
| 304 |
November 12, 2013 |
SQL SERVER – Include column header when copying or saving the results |
| 303 |
November 9, 2013 |
SQL SERVER 2012 – Security Enhancements – List of new permissions |
| 302 |
November 7, 2013 |
SQL SERVER 2012 – Fix – Error – 12824 – The sp_configure value ‘contained database authentication’ must be set to 1 |
| 301 |
November 6, 2013 |
SQL SERVER 2012- How to get the current value from a sequence object |
| 300 |
November 4, 2013 |
SQL SERVER – How to remove extra spaces from string value |
| 299 |
November 3, 2013 |
SQL SERVER 2012 – How to get a value from next result row effectively |
| 298 |
November 1, 2013 |
SQL SERVER – How to find a row that contains a lower case letter |
| 297 |
October 30, 2013 |
SQL SERVER – Fix – Error – Agent XPs component is turned off |
| 296 |
October 28, 2013 |
SQL SERVER – How to remove the trailing characters from number |
| 295 |
October 26, 2013 |
SQL SERVER 2012 – How to find if a Sequence exist in database |
| 294 |
October 24, 2013 |
SQL SERVER 2012 – Fix – Error – 11730- Database name cannot be specified for the sequence object in default constraints |
| 293 |
October 23, 2013 |
How to restore SQL SERVER 2012 backup on earlier versions of SQL Server |
| 292 |
October 8, 2013 |
SQL SERVER – How to implement conditional where clause |
| 291 |
October 5, 2013 |
SQL SERVER 2012 – How to check Sequence has reached its minimum or maximum value |
| 290 |
October 3, 2013 |
SQL SERVER – How do I get only the numbers before the decimal? |
| 289 |
September 30, 2013 |
SQL SERVER 2012 – How to check date is End of Month date or not? |
| 288 |
September 29, 2013 |
SQL SERVER 2012 – Fix – Error :11521 – The metadata could not be determined because statement ‘%.*ls’ uses an undeclared parameter in a context that affects its metadata. |
| 287 |
September 28, 2013 |
SQL SERVER 2014 – List of all Table & its Index sizes in MBs along with row count |
| 286 |
September 27, 2013 |
SQL SERVER 2012 – How to convert varchar to currency |
| 285 |
September 24, 2013 |
SQL SERVER HEKATON – Disk based table vs Memory optimized table performance |
| 284 |
September 23, 2013 |
SQL Server 2012- How to enforce uniqueness for sequence values |
| 283 |
September 22, 2013 |
SQL SERVER 2012 – Fix – Error : 41202- The source table ‘%.*ls’ specified in the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function doesn’t have a full-text index |
| 282 |
September 21, 2013 |
SQL SERVER 2012- Shortest way to calculate median |
| 281 |
September 20, 2013 |
SQL SERVER 2012- How to change datatype of Sequence Object |
| 280 |
September 18, 2013 |
SQL SERVER – Multiple ways to remove seconds & Milliseconds from Datetime (Truncate Datetime till minute) |
| 279 |
September 17, 2013 |
SQL SERVER 2014 – List of NONCLUSTERED HASH indexes |
| 278 |
September 16, 2013 |
SQL SERVER HEKATON – How to create memory optimized temporary table |
| 277 |
September 15, 2013 |
SQL SERVER 2012 – How to get First and Last day of the Year Using FORMAT function |
| 276 |
September 14, 2013 |
SQL SERVER 2012 – Fix – Error -11512 –The metadata could not be determined because the statement ‘%.*ls’ in procedure ‘%.*ls’ is not compatible. |
| 275 |
September 12, 2013 |
SQL SERVER 2012 – How to count the total number of records using OBJECTPROPERTYEX |
| 274 |
September 11, 2013 |
SQL SERVER 2012 – How to get a value from previous result row effectively |
| 273 |
September 10, 2013 |
SQL SERVER HEKATON – Simple way to count number of records in memory optimized tables |
| 272 |
September 7, 2013 |
SQL SERVER 2012 – Simple way to add variables in the dynamic SQL |
| 271 |
September 6, 2013 |
SQL SERVER – Shorter way to convert Milliseconds to Days, Hours, Minutes, Seconds & Milliseconds |
| 270 |
September 5, 2013 |
SQL SERVER 2012 – Guidelines to implement THROW Statement |
| 269 |
September 3, 2013 |
SQL SERVER HEKATON – Fix – Error – 10770 – The operation ‘ALTER TABLE’ is not supported with memory optimized tables |
| 268 |
September 2, 2013 |
SQL SERVER 2012 – Create custom snippet for Sequence object |
| 267 |
September 1, 2013 |
SQL SERVER – How to find list of tables having no records |
| 266 |
August 30, 2013 |
SQL SERVER 2012- How to format phone numbers |
| 265 |
August 28, 2013 |
SQL SERVER HEKATON – Statistics for Memory-Optimized Tables |
| 264 |
August 27, 2013 |
SQL SERVER 2012 – Fix – Error : 8116- Argument data type %ls is invalid for argument %d of %ls function |
| 263 |
August 26, 2013 |
SQL SERVER 2012 – How to register code snippet |
| 262 |
August 25, 2013 |
SQL Server – How to find Who Modified / Updated What records at What Time |
| 261 |
August 23, 2013 |
SQL SERVER – Delete Horizontal White Space |
| 260 |
August 21, 2013 |
SQL SERVER 2012 – How to convert a dd/mm/yyyy string to datetime |
| 259 |
August 20, 2013 |
SQL SERVER HEKATON – Myth – Data disappeared from the memory optimized table |
| 258 |
August 19, 2013 |
SQL SERVER – Fix – Error :119 – Must pass parameter number and subsequent parameters |
| 257 |
August 18, 2013 |
SQL SERVER 2012 – How to prevent sequence values from being changed |
| 256 |
August 17, 2013 |
SQL SERVER – How to add st, nd, rd & th to dates |
| 255 |
August 6, 2013 |
SQL SERVER HEKATON – How to update a Primary key in the memory optimized table |
| 254 |
August 4, 2013 |
SQL SERVER – How to format values as a percentage |
| 253 |
August 3, 2013 |
SQL SERVER 2012 – Fix – Error -11507 – The parameter type for ‘%.*ls’ cannot be deduced because no type would make the query valid |
| 252 |
August 2, 2013 |
SQL SERVER HEKATON – How to implement default constraints in the memory optimized table |
| 251 |
July 31, 2013 |
SQL SERVER – How to concatenate int and varchar |
| 250 |
July 30, 2013 |
SQL SERVER HEKATON – List of supportive and non-supportive data types in the memory optimized table |
| 249 |
July 28, 2013 |
SQL SERVER 2012 – How to add multiple files in a single filestream filegroup in the existing database |
| 248 |
July 27, 2013 |
SQL SERVER – How to insert space before Capital letters – User Defined Function |
| 247 |
July 26, 2013 |
SQL SERVER – Fix – Error – 11538 – EXECUTE statement failed because its WITH RESULT SETS clause |
| 246 |
July 25, 2013 |
SQL SERVER – How to pass parameters to an SP using select command (Without variables) |
| 245 |
July 24, 2013 |
SQL SERVER – String comparison as a Boolean in Select statement |
| 244 |
July 22, 2013 |
SQL SERVER – Fix – Error – 205 – All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists |
| 243 |
July 21, 2013 |
SQL SERVER HEKATON – How to create memory optimized table in an existing database |
| 242 |
July 20, 2013 |
SQL SERVER – How to find first/last occurrence of any character/ word in the string |
| 241 |
July 19, 2013 |
SQL SERVER HEKATON – How to implement BLOB data type columns in the memory optimized table |
| 240 |
July 18, 2013 |
SQL SERVER – Apply Cut or Copy commands to blank lines when there is no selection |
| 239 |
July 17, 2013 |
SQL SERVER – Connectivity with Excel |
| 238 |
July 16, 2013 |
SQL SERVER HEKATON – Fix – Error – 10770 – The %S_MSG ‘%ls’ is not supported with memory optimized tables. |
| 237 |
July 15, 2013 |
SQL SERVER HEKATON – How to implement identity column in the memory optimized table |
| 236 |
July 14, 2013 |
SQL SERVER – Extract file name from file path |
| 235 |
July 13, 2013 |
SQL SERVER HEKATON – How to find memory optimized tables in the database |
| 234 |
July 12, 2013 |
SQL SERVER – Find Weekends between Two Dates |
| 233 |
July 11, 2013 |
SQL SERVER 2012 – Fix – Error – 10761 – Invalid data type %.*ls in function %.*ls. |
| 232 |
July 10, 2013 |
SQL SERVER HEKATON – How to create Memory Optimized Table |
| 231 |
July 9, 2013 |
SQL SERVER – Date formatting in excel |
| 230 |
July 7, 2013 |
SQL SERVER HEKATON – WAIT_AT_LOW_PRIORITY |
| 229 |
July 6, 2013 |
SQL SERVER HEKATON – Northwind sample database for CTP 1 |
| 228 |
July 5, 2013 |
SQL SERVER 2014 – New system objects |
| 227 |
July 3, 2013 |
SQL SERVER 2014 – Columnstore Index Enhancement – Part 1 |
| 226 |
July 1, 2013 |
SQL SERVER 2012 – Fix – Error – 11708 – An invalid value was specified for argument ‘%.*ls’ for the given data type |
| 225 |
June 30, 2013 |
SQL SERVER 2014 – Community Technology Preview (CTP) 1, now available |
| 224 |
June 29, 2013 |
SQL SERVER – Omitted leading zeros in excel using text import wizard |
| 223 |
June 28, 2013 |
SQL SERVER – How to use ‘if… else’ in ‘where’ clause |
| 222 |
June 27, 2013 |
SQL SERVER – How to sort month names in month order instead of alphabetical order – Part II |
| 221 |
June 25, 2013 |
SQL SERVER – How can I select few column from the result set of a stored procedure |
| 220 |
June 24, 2013 |
SQL SERVER – Reuse current document window |
| 219 |
June 23, 2013 |
SQL SERVER – How to sort month names in month order instead of alphabetical order |
| 218 |
June 22, 2013 |
SQL SERVER – Fix – Error – 11537 – EXECUTE statement failed because its WITH RESULT SETS clause specified column(s) for result set number, but the statement sent column(s) at run time |
| 217 |
June 21, 2013 |
SQL SERVER 2012 – How to generate a varchar Sequence Number – Using Sequence Object |
| 216 |
June 20, 2013 |
SQL Server 2012 – Audit Enhancements – Part II |
| 215 |
June 18, 2013 |
SQL Server 2012 – Audit Enhancements – Part I |
| 214 |
June 16, 2013 |
SQL SERVER – Convert a datetime to a short date format |
| 213 |
June 15, 2013 |
SQL SERVER 2012 – Fix – Error :11525 – The metadata could not be determined because statement uses a temp table. |
| 212 |
June 14, 2013 |
SQL SERVER 2014 Announcement & its features |
| 211 |
June 13, 2013 |
SQL SERVER – How to insert a string value with an apostrophe (single quote) in a column |
| 210 |
June 12, 2013 |
SQL SERVER 2012 – Scalability and Performance Enhancements – FILESTREAM Filegroups Can Contain Multiple Files |
| 209 |
June 11, 2013 |
SQL SERVER – How to extract numeric and special characters separately |
| 208 |
June 10, 2013 |
SQL SERVER 2012 – Fix – Error :11724 – An expression that contains a NEXT VALUE FOR function cannot be passed as an argument to a table-valued function |
| 207 |
June 9, 2013 |
SQL Server 2012 – Debugger Enhancements |
| 206 |
June 8, 2013 |
SQL SERVER – Extract part of a string |
| 205 |
June 7, 2013 |
SQL SERVER – how to remove first two characters from year |
| 204 |
June 6, 2013 |
SQL SERVER – How to sum a varchar column |
| 203 |
June 4, 2013 |
SQL SERVER – How to store more than 8000 characters in a column |
| 202 |
June 3, 2013 |
SQL SERVER – Fix – Error :4127 – At least one of the arguments to COALESCE must be a typed NULL |
| 201 |
June 1, 2013 |
SQL SERVER 2012 – Discontinued Functionality – RAISERROR syntax |
| 200 |
May 31, 2013 |
SQL Server – Convert short month name to month name |
| 199 |
May 31, 2013 |
SQL SERVER – Passing multiple values through one parameter in a stored procedure |
| 198 |
May 30, 2013 |
SQL SERVER – Multiple ways to remove Milliseconds from Datetime (Truncate Datetime till Second) |
| 197 |
May 28, 2013 |
SQL SERVER – Fix – Error :156 – Incorrect syntax near the keyword ‘UNION’. |
| 196 |
May 27, 2013 |
SQL SERVER 2012 – Differences between RAISERROR and THROW with examples |
| 195 |
May 25, 2013 |
SQL SERVER – Faster way to calculate running total |
| 194 |
May 24, 2013 |
SQL SERVER – Resetting sequence values for entire database |
| 193 |
May 23, 2013 |
SQL SERVER – How to get short month name / weekday name from datetime |
| 192 |
May 22, 2013 |
SQL SERVER 2012 – Fix – Error :11508 – The undeclared parameter is used more than once in the batch being analyzed |
| 191 |
May 21, 2013 |
SQL SERVER – Shorter way to convert Minutes to Days, Hours, Minutes |
| 190 |
May 20, 2013 |
SQL SERVER – TRIM – How to remove leading and trailing characters/Spaces from string |
| 189 |
May 19, 2013 |
SQL Server – Multiple ways to convert Month name to Month number |
| 188 |
May 18, 2013 |
SQL Server – Multiple ways to achieve Dynamically Order By Clause |
| 187 |
May 17, 2013 |
SQL SERVER – Fix – Error :1969 – Default FILESTREAM filegroup is not available in database |
| 186 |
May 16, 2013 |
SQL SERVER – Excel Financial functions – PMT |
| 185 |
May 15, 2013 |
SQL SERVER 2012 – Behavior Changes – sqlcmd Utility |
| 184 |
May 14, 2013 |
SQL SERVER – How To Convert From Boolean(bit) to String |
| 183 |
May 13, 2013 |
SQL SERVER 2012 – How to create a customized snippet |
| 182 |
May 11, 2013 |
SQL SERVER 2012 – Stored Procedure – Insert into exec with result set is Possible |
| 181 |
May 10, 2013 |
SQL SERVER 2012 – Fix – Error :365 – The query processor could not produce a query plan because the FORCESEEK hint on table or view specified more seek columns than the number of key columns in index. |
| 180 |
May 8, 2013 |
SQL SERVER – How to convert Gregorian dates to Hijri date with Formatting |
| 179 |
May 7, 2013 |
SQL SERVER – How to find outdated statistics |
| 178 |
May 6, 2013 |
SQL SERVER 2012 – Semantic Search – Implementation– Part-2 |
| 177 |
May 5, 2013 |
SQL SERVER 2012 – Semantic Search – Install and configure – Part-1 |
| 176 |
May 4, 2013 |
SQL SERVER 2012 – Fix – Error :11513 – The metadata could not be determined because statement contains dynamic SQL. Consider using the WITH RESULT SETS clause to explicitly describe the result set. |
| 175 |
May 3, 2013 |
SQL SERVER 2012 – Insert Snippet … |
| 174 |
May 2, 2013 |
SQL SERVER – Multiple ways to convert month number to month name |
| 173 |
May 1, 2013 |
SQL SERVER – Omitted leading zeros in excel |
| 172 |
April 30, 2013 |
SQL SERVER – How to implement LIMIT with performance |
| 171 |
April 30, 2013 |
SQL SERVER 2012 – Fix – Error :35327- ALTER INDEX REBUILD statement failed because specifying FILLFACTOR is not allowed when rebuilding a columnstore index. Rebuild the columnstore index without specifying FILLFACTOR. |
| 170 |
April 29, 2013 |
SQL SERVER – How to search a string value in all columns in the table and in all tables in all databases in all databases – Part 2 |
| 169 |
April 28, 2013 |
SQL SERVER – How to search a string value in all columns in the table and in all tables in a database – Part 1 |
| 168 |
April 26, 2013 |
SQL SERVER – How to convert varchar to float |
| 167 |
April 25, 2013 |
SQL SERVER – Get Month Name from date using format function |
| 166 |
April 24, 2013 |
SQL SERVER – How to recover the dropped Indexes without Backup |
| 165 |
April 23, 2013 |
SQL SERVER 2012 – Fix – Error : 366 – The query processor could not produce a query plan because the FORCESEEK hint on table or view cannot be used with the column store index |
| 164 |
April 22, 2013 |
SQL SERVER 2012 – Breaking Changes – sys.dm_os_memory_cache_counters |
| 163 |
April 21, 2013 |
SQL SERVER – How to convert float to varchar |
| 162 |
April 20, 2013 |
SQL SERVER – How to find SQL Server port number |
| 161 |
April 18, 2013 |
SQL SERVER – Get day of week in SQL 2005/2008/2012 |
| 160 |
April 17, 2013 |
SQL SERVER 2012 – Fix – Error :11514 – The metadata could not be determined because statement in procedure contains dynamic SQL. Consider using the WITH RESULT SETS clause to explicitly describe the result set. |
| 159 |
April 16, 2013 |
SQL SERVER 2012 – FORCESEEK Table Hint – Enhancement |
| 158 |
April 15, 2013 |
SQL SERVER – Undocumented function – fn_dblog |
| 157 |
April 14, 2013 |
SQL SERVER – How to find uncontained objects in the database |
| 156 |
April 12, 2013 |
SQL SERVER – Get the first letter of each word in a String (Column) |
| 155 |
April 11, 2013 |
SQL SERVER 2012 – Fix – Error : 35343 – CREATE INDEX statement failed. Column has a data type that cannot participate in a columnstore index. Omit column. |
| 154 |
April 10, 2013 |
SQL SERVER – Shorter way to convert Seconds to Days, Hours, Minutes, Seconds |
| 153 |
April 9, 2013 |
SQL SERVER 2012- Shortcut – How to find all system objects related to any filetable |
| 152 |
April 8, 2013 |
SQL SERVER 2012 – Deprecated Features – Ability to return result sets from triggers |
| 151 |
April 6, 2013 |
SQL SERVER – Finding Size of a Columnstore Index on disk |
| 150 |
April 5, 2013 |
SQL SERVER 2012 – Fix – Error – 11728 – The sequence object has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated |
| 149 |
April 4, 2013 |
SQL SERVER 2012 – How to find list of contained databases |
| 148 |
April 3, 2013 |
SQL SERVER 2012 – Get Day, Month and Year separately from Date Time Using Format Function |
| 147 |
April 2, 2013 |
SQL SERVER – How to convert Hashbytes to varchar |
| 146 |
April 1, 2013 |
SQL SERVER – Cryptographic Functions – HASHBYTES – Enhancement |
| 145 |
March 31, 2013 |
SQL SERVER 2012 – Fix – Error – 35330 – Statement failed because data cannot be updated in a table with a columnstore index. Consider disabling the columnstore index before issuing the %S_MSG statement, then rebuilding the columnstore index after S_MSG is complete. |
| 144 |
March 31, 2013 |
SQL SERVER – Rebuild/ Enable all indexes (Including Nonclustered Columnstore Indexes) – Part 3 |
| 143 |
March 30, 2013 |
SQL SERVER – Disable all indexes (Including Nonclustered Columnstore Indexes) – Part 2 |
| 142 |
March 29, 2013 |
SQL SERVER – List of all indexes with column name and datatype (including columnstore index) – Part 1 |
| 141 |
March 28, 2013 |
SQL SERVER – Fix – Error – 11536 – EXECUTE statement failed because its WITH RESULT SETS clause specified result set(s), but the statement only sent result set(s) at run time. |
| 140 |
March 27, 2013 |
SQL SERVER – Multiple ways to calculate the number of days in a Year |
| 139 |
March 26, 2013 |
SQL SERVER 2012 – Breaking Changes – sys.dm_exec_requests |
| 138 |
March 25, 2013 |
SQL SERVER – Find tables across the databases |
| 137 |
March 24, 2013 |
SQL SERVER 2012 – Recovery Adviser |
| 136 |
March 22, 2013 |
SQL SERVER 2012 – Fix – Error – The culture parameter provided in the function call is not supported |
| 135 |
March 20, 2013 |
SQL SERVER 2012 – Behavior Changes – exist() function |
| 134 |
March 19, 2013 |
SQL SERVER – Multiple ways to get Date and Time separately from DateTime |
| 133 |
March 18, 2013 |
SQL SERVER – sys.dm_os_sys_info – dynamic management view |
| 132 |
March 17, 2013 |
SQL SERVER 2012 – Columnstore Index |
| 131 |
March 15, 2013 |
SQL SERVER 2012 – Fix – Error – sp_describe_first_result_set cannot be invoked when SET STATISTICS XML or SET STATISTICS PROFILE is on |
| 130 |
March 14, 2013 |
SQL SERVER- How to insert multilingual data in a Table |
| 129 |
March 13, 2013 |
SQL SERVER 2012 – Discontinued Features – DATABASEPROPERTY |
| 128 |
March 12, 2013 |
SQL SERVER – String Concatenation – Faster Method |
| 127 |
March 11, 2013 |
SQL SERVER – Function to parse alphanumeric characters from string |
| 126 |
March 10, 2013 |
SQL SERVER 2012 – Mathematical Functions – LOG() |
| 125 |
March 08, 2013 |
SQL SERVER – EXECUTE statement failed because its WITH RESULT SETS clause specified result set(s), and the statement tried to send more result sets than this |
| 124 |
March 07, 2013 |
SQL SERVER 2012 – Breaking Changes – ALTER TABLE statements |
| 123 |
March 06, 2013 |
SQL SERVER – Database Mail – Easiest way to send a HTML formatted emails |
| 122 |
March 04, 2013 |
SQL SERVER – How to convert user defined objects to system objects |
| 121 |
March 03, 2013 |
SQL SERVER 2012–Discontinued Features-CREATE TRIGGER-WITH APPEND clause |
| 120 |
March 02, 2013 |
SQL SERVER – DBCC SHRINKFILE for FILESTREAM containers requires EMPTYFILE option and does not allow any other options |
| 119 |
February 28, 2013 |
SQL SERVER – Retrieve Processes Using Specified Database |
| 118 |
February 27, 2013 |
SQL SERVER – The metadata could not be determined because the statement is not compatible with the statement |
| 117 |
February 27, 2013 |
SQL SERVER – How to run sp_spaceused for all tables in a database |
| 116 |
February 25, 2013 |
SQL SERVER – Excel Financial Functions – using CLR |
| 115 |
February 24, 2013 |
SQL SERVER – Dont’s for Offset Rows And Fetch Next |
| 114 |
February 22, 2013 |
Step by Step – Data Migration from Excel 2007 and above to SQL SERVER |
| 113 |
February 21, 2013 |
SQL SERVER – Clear Find and Replace window history |
| 112 |
February 20, 2013 |
SQL SERVER – DROP ASSEMBLY failed because ‘%ls’ is referenced by object ‘%ls’ |
| 111 |
February 19, 2013 |
SQL SERVER – Best way to check all database autogrowth settings |
| 110 |
February 18, 2013 |
SQL SERVER 2012 – AUTO RECOVERY SCRIPTS |
| 109 |
February 17, 2013 |
SQL SERVER – A TOP cannot be used in the same query or sub-query as an OFFSET |
| 108 |
February 16, 2013 |
SQL SERVER 2012 – Changing a table from identity to sequence (Automatically) |
| 107 |
February 16, 2013 |
SQL SERVER 2012 – Changing a table from identity to sequence (Manually) |
| 106 |
February 14, 2013 |
SQL SERVER – Trace Query in SQL SERVER Profiler |
| 105 |
February 13, 2013 |
SQL SERVER 2012 – Analytic Functions – PERCENTILE_CONT |
| 104 |
February 11, 2013 |
SQL SERVER – Enhance word count function |
| 103 |
February 10, 2013 |
SQL SERVER – The batch could not be analyzed because of compile errors |
| 102 |
February 09, 2013 |
SQL SERVER 2012 – Cycle Clipboard Ring |
| 101 |
February 08, 2013 |
SQL SERVER – Present value of Annuity(PV) |
| 100 |
February 07, 2013 |
SQL SERVER – Future value of Annuity(FV) |
| 99 |
February 06, 2013 |
SQL SERVER 2012- How to identify a File Table |
| 98 |
February 05, 2013 |
SQL SERVER 2012 – FileTables – Data Manipulation Language (DML) Statements |
| 97 |
February 04, 2013 |
SQL SERVER 2012 – FileTables – Data Definition Language (DDL) Statements |
| 96 |
February 03, 2013 |
SQL SERVER 2012 – FileTables – Prerequisites- Enable / Create / Alter |
| 95 |
February 02, 2013 |
SQL SERVER 2012- sp_describe_undeclared_parameters – System stored procedure |
| 94 |
January 31, 2013 |
SQL SERVER – Stored Procedure – Insert into exec with result set. |
| 93 |
January 31, 2013 |
SQL SERVER – Remove Recent files history from the menu |
| 92 |
January 30, 2013 |
SQL SERVER – How to recover the recent executed query |
| 91 |
January 29, 2013 |
SQL SERVER – ALL ABOUT OBJECT_ID |
| 90 |
January 28, 2013 |
SQL SERVER – Mass renaming of sql tables |
| 89 |
January 27, 2013 |
SQL SERVER – Window frame with ROWS or RANGE must have an ORDER BY clause |
| 88 |
January 26, 2013 |
SQL SERVER 2012 -Date and Time Function – DATETIMEOFFSETFROMPARTS |
| 87 |
January 25, 2013 |
SQL SERVER – How to view the column information of table or view without executing any query. |
| 86 |
January 24, 2013 |
SQL SERVER 2012 – sys.dm_db_database_page_allocations – dynamic management function |
| 85 |
January 23, 2013 |
SQL SERVER 2012 – Detecting Leap Year in T-SQL using SQL SERVER 2012 Functions |
| 84 |
January 22, 2013 |
SQL SERVER – Web Browser – Explorer settings |
| 83 |
January 20, 2013 |
SQL SERVER 2012 – sp_sequence_get_range – System Stored Procedure |
| 82 |
January 18, 2013 |
SQL SERVER – Cannot construct data type %ls, some of the arguments have values which are not valid. |
| 81 |
January 17, 2013 |
SQL SERVER – Find Weekdays Between Two Dates |
| 80 |
January 16, 2013 |
SQL SERVER – MANAGEMENT COMMAND – DBCC CHECKIDENT |
| 79 |
January 15, 2013 |
SQL SERVER 2012 – sys.dm_exec_describe_first_result_set_for_object – dynamic management function |
| 78 |
January 10, 2013 |
SQL SERVER – Split String into Rows based on multiple delimiters |
| 77 |
January 09, 2013 |
SQL SERVER 2012 – Surrounded With |
| 76 |
January 08, 2013 |
SQL SERVER 2012 – Analytic Functions – PERCENT_RANK |
| 75 |
January 07, 2013 |
SQL SERVER – Remove Duplicate Entry from Comma Delimited String |
| 74 |
January 06, 2013 |
SQL SERVER – Get Number of Days in a Month |
| 73 |
January 03, 2013 |
SQL SERVER – User Defined Function – Parse HTML |
| 72 |
December 19, 2012 |
SQL SERVER – Function to Extract Numbers From String |
| 71 |
December 18, 2012 |
SQL SERVER – Create Comma Separated List From Table |
| 70 |
December 13, 2012 |
SQL SERVER – Proper Case User-Defined Function |
| 69 |
December 12, 2012 |
SQL SERVER – All Table & its Index sizes in MBs |
| 68 |
December 10, 2012 |
SQL SERVER 2012 – Analytic Functions – CUME_DIST |
| 67 |
December 04, 2012 |
SQL SERVER – Recover the dropped Objects (View, Stored Procedure, Function & Trigger) |
| 66 |
December 03, 2012 |
SQL SERVER – Discard result after query execution |
| 65 |
November 30, 2012 |
SQL SERVER 2012 – Analytic Functions – LEAD |
| 64 |
November 21, 2012 |
SQL SERVER 2012 – Analytic Functions – LAG |
| 63 |
October 27, 2012 |
SQL SERVER – Selecting Domain from Email Address |
| 62 |
October 24, 2012 |
SQL SERVER – How to find Who Deleted What records at What Time |
| 61 |
October 24, 2012 |
SQL SERVER 2012 – List of all sequences available in the Database |
| 60 |
October 23, 2012 |
SQL SERVER – Using Decode in SQL SERVER |
| 59 |
October 23, 2012 |
SQL SERVER 2012– Change Color & Theme of SQL SERVER Management Studio(SSMS) |
| 58 |
October 22, 2012 |
SQL SERVER – Multiple ways to find identity column |
| 57 |
October 20, 2012 |
SQL SERVER 2012 – T-SQL Scripts to Find Maximum between |
| 56 |
October 20, 2012 |
SQL SERVER – Change Database Compatibility Level |
| 55 |
October 17, 2012 |
SQL SERVER – DO’s & Don’ts of sp_rename |
| 54 |
October 16, 2012 |
SQL SERVER – Best way to get Table Row Count |
| 53 |
October 15, 2012 |
SQL SERVER – add column in the middle of table |
| 52 |
October 15, 2012 |
SQL SERVER – Compare two databases schema |
| 51 |
October 14, 2012 |
SQL SERVER 2012– Convert Text to Numbers |
| 50 |
October 13, 2012 |
SQL SERVER 2012- Date Formats |
| 49 |
October 12, 2012 |
SQL SERVER 2012 – Insert New tab to the right side of existing tabs Instead of left |
| 48 |
October 11, 2012 |
SQL SERVER – How to get list of disable and enable triggers from database with description |
| 47 |
October 11, 2012 |
SQL SERVER – SHORTCUT IN SQL SERVER MANAGEMENT STUDIO |
| 46 |
October 10, 2012 |
How to recover the deleted records from SQL SERVER |
| 45 |
October 09, 2012 |
SQL SERVER 2005/2008/2012 – Leading Zero to Number |
| 44 |
October 08, 2012 |
SQL SERVER – How to recover the renamed table |
| 43 |
October 07, 2012 |
SQL SERVER-Convert varbinary to numeric & vice versa |
| 42 |
October 07, 2012 |
SQL SERVER 2012 – Contained Database |
| 41 |
October 03, 2012 |
SQL SERVER – Find stored procedure across databases |
| 40 |
October 03, 2012 |
SQL SERVER – How to insert Multiple Records Using One Insert Statement |
| 39 |
September 30, 2012 |
How to get hour, minute & second from date time |
| 38 |
September 30, 2012 |
Generating INSERT statements in SQL SERVER 2012 |
| 37 |
September 25, 2012 |
Generating Insert statements, data & schema using SQL SERVER Publishing Wizard |
| 36 |
September 19, 2012 |
SQL SERVER 2012 – String Function – FORMAT |
| 35 |
September 11, 2012 |
SQL SERVER 2012 – String Function – CONCAT |
| 34 |
September 10, 2012 |
How to get First day of a month in SQL SERVER 2012 (FOMONTH) |
| 33 |
September 10, 2012 |
SQL SERVER 2012 -Date and Time Function – EOMONTH |
| 32 |
September 07, 2012 |
SQL SERVER 2012 -Date and Time Function – DATETIME2FROMPARTS |
| 31 |
September 07, 2012 |
SQL SERVER 2012 -Date and Time Function – SMALLDATETIMEFROMPARTS |
| 30 |
September 06, 2012 |
SQL SERVER 2012 -Date and Time Function – DATETIMEFROMPARTS() |
| 29 |
September 04, 2012 |
SQL SERVER 2012 -Date and Time Function -TIMEFROMPARTS() |
| 28 |
August 31, 2012 |
SQL SERVER 2012 -Date and Time Function – DATEFROMPARTS() |
| 27 |
August 30, 2012 |
SQL SERVER 2012 – Analytic Function – LAST_VALUE |
| 26 |
August 29, 2012 |
SQL SERVER 2012 – Analytic Function – FIRST_VALUE |
| 25 |
August 28, 2012 |
SQL SERVER 2012 -Conversion Function -TRY_CAST |
| 24 |
August 27, 2012 |
SQL SERVER 2012 -Conversion Function -TRY_CONVERT |
| 23 |
August 27, 2012 |
SQL SERVER 2012 -Conversion Function -TRY_PARSE() |
| 22 |
August 26, 2012 |
SQL SERVER 2012 -Conversion Function – PARSE () |
| 21 |
August 06, 2012 |
SQL SERVER 2012 – New Logical Function – IIF |
| 20 |
August 05, 2012 |
SQL SERVER 2012 – New Logical Function – CHOOSE |
| 19 |
July 29, 2012 |
SQL SERVER 2012 – sys.dm_exec_describe_first_result_set – dynamic management function |
| 18 |
July 04, 2012 |
SQL SERVER 2012 – sp_describe_first_result_set – System Stored Procedure |
| 17 |
July 03, 2012 |
SQL SERVER 2012 – Error Handling – Using THROW |
| 16 |
July 02, 2012 |
SQL SERVER 2012– Executing Stored Procedure with Result Sets |
| 15 |
July 01, 2012 |
SQL Paging in SQL SERVER 2012 using ORDER BY OFFSET and FETCH NEXT |
| 14 |
June 27, 2012 |
Install Sample Database – Adventureworks in SQL SERVER 2012 |
| 13 |
May 01, 2012 |
Difference between Identity and Sequence in SQL SERVER 2012 |
| 12 |
April 29, 2012 |
How sequence works in SQL SERVER 2012 |
| 11 |
April 24, 2012 |
How to create Bulk SQL Users |
| 10 |
April 18, 2012 |
How to convert Iranian Calendar to Gregorian Calendar & vice versa. |
| 09 |
April 17, 2012 |
How to Change the Default SQL SERVER backup folder |
| 08 |
April 08, 2012 |
How to recover truncated data from SQL SERVER without Backup |
| 07 |
February 14, 2012 |
Split Function in SQL SERVER |
| 06 |
February 01, 2012 |
How to recover modified records from SQL SERVER without Backup Explanation |
| 05 |
February 01, 2012 |
How to recover modified records from SQL SERVER without Backup |
| 04 |
January 23, 2012 |
How to recover deleted data from SQL SERVER 2000 |
| 03 |
December 21, 2011 |
How to use multiple values for IN clause using same parameter (SQL SERVER) |
| 02 |
December 20, 2011 |
How to generate Insert statements from table data using SQL SERVER |
| 01 |
October 22, 2011 |
How to recover deleted data from SQL SERVER |
SQL Server Portal 
Hi Respected Imran,
Hope you are doing well,
I have read all of your articles they are fantastic and helps me a lot.
But there is one more thing I want to ask from you can you please share the code that how to recover dropped table with data and structure.
Thanks