Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,107 reads
Scripts
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
909 reads
Remove Logins Script
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,323 reads
2012-03-30 (first published: 2008-04-21)
3,206 reads
Generate index on foreign key columns
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,352 reads
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,349 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,105 reads
2012-03-26 (first published: 2008-01-23)
3,232 reads
Different Date Formats
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast
2012-03-23 (first published: 2007-10-26)
3,678 reads
Split Function to break the Job History Message into a Table
Split Function for T-SQL Server to break the Job History Message into Table.
2012-03-22 (first published: 2012-03-05)
1,069 reads
Blogs
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
Forums
clean up accounts
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Exploring SQL Learning Resources for Aspiring Study Abroad Students in Jaipur
Hello Everyone! 👨💻👩💻 Are you preparing to study abroad and considering a career in...
(Alone) #call #girl In 0562088713 downtown Dubai
(Alone) #call #girl In 0562088713 Downtown Dubai (Alone) #call #girl In 0562088713 Downtown Dubai
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers