Shrinking the log file script for SQL server database
AdvertisementsShrinking the log file script for SQL server database
This script mainly for a DBA’s, because most of the time...
2011-04-10
2,000 reads
AdvertisementsShrinking the log file script for SQL server database
This script mainly for a DBA’s, because most of the time...
2011-04-10
2,000 reads
Advertisements
INDEX DEFRAGMENTATION SCRIPT SQL 2000
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance....
2011-03-12
1,838 reads
Advertisements
T-SQL Tuesday #015: Automation:
I am very much interested to participate in the T-SQL Tuesday event party. I have seen the...
2011-02-06
973 reads
AdvertisementsHow to setup the DB mail using Gmail account
In this article I am going to show the database mail setup...
2011-02-05
730 reads
AdvertisementsSQLskills Master Immersion Events 2011 competition
I have completed engineering and my native is M.Uthamasolagan (village near chidambaram ). I have...
2011-01-24
618 reads
Advertisements
One day I got a call from my junior DBA. She asked me, how can I find out the port...
2011-01-19
540 reads
Happy moments in 2010
Hi all wish you a happy new year.
I know it’s a late post anyway I am going...
2011-01-07
1,420 reads
AdvertisementsClustered index vs Non clustered index structure
Clustered and Non clustered indexes are stored in a B – tree structure .
Clustered...
2010-12-02
2,628 reads
Advertisements
INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005
I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me...
2010-11-23
1,488 reads
Advertisements
In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.
SQL–Structured Query...
2010-11-23
1,563 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers