|
|
-
Nakul Vachhrajani Liked 1 Years ago through Just Learned | 1 Point
I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and 0
|
-
Nakul Vachhrajani Liked 1 Years ago through Just Learned | 1 Point
This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424
The task was to extract 7 digit numbers from a string.
My solution is a simple straight-forward recursive CTE, although perhaps a bett
|
-
Nakul Vachhrajani Liked 1 Years ago through Just Learned | 1 Point
I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of ident
|
-
Nakul Vachhrajani Liked 1 Years ago through Just Learned | 1 Point
How do I know which deprecated features I’m using?
To find out, run the following query:
[code]
SELECT instance_name AS 'Deprecated Feature', cntr_value AS 'Times Used'
FROM sys.dm_os_performance_counters
WHERE object_name = 'SQLServer:Deprecated Feat
|
-
Nakul Vachhrajani Liked 1 Years ago through Just Learned | 1 Point
I just learned from Jacob sir that one can capture (only) the active window by using ALT + PrtScn command. Previosuly i used snipping tool for capturing "active windows" but now having learned about ALT + PrtScn would make my life easier. It's a nice keybo
|
-
Nakul Vachhrajani Posted 1 Years ago through Just Learned | 5 Points
Just learned this nice trick from Aaron Bertrand's post to add column names to a query instead of using SELECT *.
Apparently, SSMS has a provision to drag-drop the "columns" node to the query editor and SSMS will add all columns of the table to your scr
|
-
Nakul Vachhrajani Liked 2 Years ago through Just Learned | 1 Point
I am a fan of hashtags on twitter because it makes categorizing and searching content very easy. sql server community has a great hashtag (#sqlhelp) for quick QA's on sql server. Any-who i found that "#"'s are searchable in Google+ too.
|
-
Nakul Vachhrajani Liked 2 Years ago through Just Learned | 1 Point
SET PARSEONLY ON Examines the syntax of each Transact-SQL statement and returns any error messages without compiling or executing the statement.
[code]
SET PARSEONLY { ON | OFF }
[/code]
When SET PARSEONLY is ON, SQL Server only parses the statement.
|
-
Nakul Vachhrajani Liked 2 Years ago through Just Learned | 1 Point
While you are working in Query window, if you want to delete the current row, you have to highlight entire row and press delete key. Another alternate is to use SHIFT+DEL key. The cursor can be at any position and the entire row will be deleted
|
-
Nakul Vachhrajani Liked 2 Years ago through Just Learned | 1 Point
Its Chrismas and New Year holiday time. Both Google & Microsoft seems to be playing same "Let it snow" competition.
1. Go to google.com and search for "Let it snow". Press enter.
2. Go to below URL.
http://ie.microsoft.com/testdrive/perf
|