DML, DDL, DCL, TCL in SQL Server
Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...
2011-05-28
11,727 reads
Blog Posts
Restoring a database from higher version to lower version SQL server
AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...
2011-05-28
3,038 reads
Using Views for Faster SQL Query Development
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...
2011-05-28
845 reads
Re-blog – May 20-26
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-27
840 reads
Search Active Directory (AD) from your desktop
Ever see a Windows group and want to know all the users in that group without having to ask your...
2011-05-27
685 reads
SQL University Troubleshooting Week: Having a Plan for Every Situation
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
725 reads
Endpoints Need Privileges Too
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,276 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I scheduled exam 70-433 for first thing in the morning...
2011-05-26
5 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I...
2011-05-26
588 reads
No Shrink-y Tempdb
I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal),...
2011-05-26
1,609 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers