440 |
Dec 16, 2022 |
SQL Server 2022 – Improved backup metadata – last_valid_restore_time |
439 |
Dec 15, 2022 |
SQL Server 2022 – TSQL – QAT_DEFLATE – Default Database Backup Compression Algorithm |
437 |
Dec 13, 2022 |
SQL Server 2022 – TSQL – MS_XPRESS – Default Database Backup Compression Algorithm |
436 |
Dec 12, 2022 |
SQL Server 2022 – Error – Fix – Invalid column name ‘ordinal’ |
435 |
Dec 9, 2022 |
SQL Server 2022 – TSQL Enhancement – STRING_SPLIT() Function |
434 |
Dec 8, 2022 |
SQL Server 2022 – TSQL – How to get previous, current and last week dates using DATETRUNC() function |
433 |
Dec 7, 2022 |
SQL Server 2022 – TSQL – How to get previous, current and last quarter dates using DATETRUNC() function |
432 |
Dec 6, 2022 |
SQL Server 2022 – TSQL – How to get previous, current and last month dates using DATETRUNC() function |
431 |
Dec 5, 2022 |
SQL Server 2022 – TSQL – How to get previous, current and last year dates using DATETRUNC() function |
430 |
Dec 2, 2022 |
SQL Server 2022 – Fix – Error – Procedure expects parameter ‘separator’ of type ‘nchar(1)/nvarchar(1) |
429 |
Dec 1, 2022 |
SQL Server – STRING_AGG() Function |
428 |
Nov 30, 2022 |
SQL Server – CONCAT_WS() Function |
427 |
Nov 29, 2022 |
SQL Server – CONCAT() Function |
|
426 |
Nov 28, 2022 |
SQL Server – String Functions – STRING_SPLIT() |
425 |
Nov 25, 2022 |
SQL Server 2022 – How to generate Sample table using GENERATE_SERIES() function |
424 |
Nov 24, 2022 |
Azure Data Studio – Extensions – Compare Schema |
423 |
Nov 23, 2022 |
SQL Server 2022 – How to generate calendar table using GENERATE_SERIES() function |
422 |
Nov 22, 2022 |
SQL Server 2022 – TSQL – SELECT – WINDOW() Clause |
421 |
Nov 21, 2022 |
SQL Server 2022 is released on 16 Nov 2022 |
420 |
Nov 16, 2022 |
SQL Server 2022 – GENERATE_SERIES() Function |
419 |
Nov 14, 2022 |
SQL Server – Fix – The second and third arguments of the TRANSLATE built-in function must contain an equal number of characters |
418 |
Nov 12, 2022 |
Scared of User Defined Function in SQL Server but Not Anymore |
417 |
Nov 9, 2022 |
SQL Server 2022 – TSQL Enhancement – RTRIM() Function |
416 |
Nov 8, 2022 |
SQL Server 2022 – TSQL Enhancement – LTRIM() Function |
415 |
Nov 7, 2022 |
SQL Server 2022 – TSQL Enhancements – TRIM() Function |
414 |
Nov 5, 2022 |
SQL Server – String Functions – TRANSLATE() |
413 |
Nov 4, 2022 |
SQL Server 2022 – Date & Time Function – DATETRUNC() |
412 |
Nov 1, 2022 |
Azure Data Studio – Extensions – Query History |
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 |
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