Brilliant! I’ve been working SQL Server since 7.0 and the various interfaces. I’ve been working with SSMS for so long that I thought, ‘eh, pretty certain I know my way around it I’ll check it out.’ I’m open to learning something to make me more efficient. ‘F7’ was quite interesting. Didn’t know that before this. I didn’t know you could drag “Columns” to the editor or hover over * to see the columns in the SELECT list. The clipboard ring was a new thing for me. I spend a lot of time tuning queries and in the execution plan. I’ve known about that little + for a while. Good to show others. Still tripping out over the ‘F7’ details. I typically write scripts to write scripts for me. Script out the dropping or creation of constraints, or any object, for that matter, generation of c# code for a stored procedure/function. It’s a lot faster to write a T-SQL statement to do the repetitive work for me. I give it an object name and milliseconds later, I can copy and paste.
I was searching many thing which you have taught here. I didn't find most of the things in the web which I found here. This video is like finding a treasure box out of nowhere. Than You so much Sir.
Well, it would be great to follow the instructions and everything being said there but without an existing/accessible data base the commands will remain theoretical.
my problem in sql is when i upload data with decimals, SQL automatically round up/down decimals. And when i divide, it automatically round up. i'm a newbie here.
Great video. Thanks. Even though this is a year old, I have a question. I have a folder on one drive where I wrote code, but I can't find it using explorer. How can I search for code in *.qry files? Thank you!
Brilliant! I’ve been working SQL Server since 7.0 and the various interfaces. I’ve been working with SSMS for so long that I thought, ‘eh, pretty certain I know my way around it I’ll check it out.’ I’m open to learning something to make me more efficient.
‘F7’ was quite interesting. Didn’t know that before this. I didn’t know you could drag “Columns” to the editor or hover over * to see the columns in the SELECT list.
The clipboard ring was a new thing for me.
I spend a lot of time tuning queries and in the execution plan. I’ve known about that little + for a while. Good to show others.
Still tripping out over the ‘F7’ details.
I typically write scripts to write scripts for me. Script out the dropping or creation of constraints, or any object, for that matter, generation of c# code for a stored procedure/function. It’s a lot faster to write a T-SQL statement to do the repetitive work for me. I give it an object name and milliseconds later, I can copy and paste.
I see a few tricks I know and use, and a few I'm going to make a point of getting into regular use. Thanks for the content.
I was searching many thing which you have taught here. I didn't find most of the things in the web which I found here. This video is like finding a treasure box out of nowhere.
Than You so much Sir.
You're very welcome!
Thank you very much for sharing your knowledge, Sir!! Great exposition!
Thank you for sharing your Brilient knowledge with us .
Very useful. Thanks
Valuable, thanks!
I'm a new DBA for a tiny cloud database. Extremely helpful!!!
Impressive!
Thank you, I'll subscribe to SDU immediately.
Thanks Sir for making such informative video, You are Very Helpful !
You really saved me from lot of worries. Thanks
Amazing! Thank you Greg!
Thank you very much, this helped me a lot. 🤩
Thanks alot..This is great video....Thumbnail not justifying greatness of information provided in video
Well, it would be great to follow the instructions and everything being said there but without an existing/accessible data base the commands will remain theoretical.
Wow ,this is really helpful .
Great tricks! Thanks a lot!
Wow, very clear and useful. Thanks!!!
Great!!
Thank you. Good one
Thanks SDU. I learned a couple of useful tips from this though I've been using SSMS for several years. Do you have tips for Data Studio?
👏great tips
Great video 👍
my problem in sql is when i upload data with decimals, SQL automatically round up/down decimals. And when i divide, it automatically round up. i'm a newbie here.
Great video. Thanks. Even though this is a year old, I have a question. I have a folder on one drive where I wrote code, but I can't find it using explorer. How can I search for code in *.qry files? Thank you!
it's really used
"heeyah"? did I spell that right? what does it mean?
good
How do i version control using ssms ?
nice