Ritesh Shah is an author of many technical article on Microsoft Technology, especially on SQL-Server, .NET technology like C# and ASP.Net etc. He is having 10+ year of experience in IT industry and working as Consultant Project Leader and Database Administrator.
He is very active community member, you can find him at:
SQLHub.com
Experts-Exchange.com
Asp.Net
LinkedIN
Beyond-Relational
Twitter
SQL Server 2012 Performance Tuning book by Ritesh Shah
 | Soumya Ranjan Samant… on Image store in SQL-Server 2005… |
 | Jeff Moden on Table statistics in SQL Server… |
 | Twitter on Read XLS or MDB file with Open… |
 | Kelli Dudley on LOG function in SQL Server and… |
 | Jason on DDL Trigger in SQL-Server 2005… |
 | Amit Kumar Gupta on DDL Trigger in SQL-Server 2005… |
 | riteshshah on Image store in SQL-Server 2005… |
 | Soumya Ranjan Samant… on Image store in SQL-Server 2005… |
 | BYRON on Read XLS or MDB file with Open… |
| How to Remove Duplic… on Delete-Select-Duplicate-Record… |
Ritesh Shah is an author of many technical article on Microsoft Technology, especially on SQL-Server, .NET technology like C# and ASP.Net etc. He is having 10+ year of experience in IT industry and working as Consultant Project Leader and Database Administrator.
He is very active community member, you can find him at:
SQLHub.com
Experts-Exchange.com
Asp.Net
LinkedIN
Beyond-Relational
Twitter
Extreme-Advice.com
Ritesh's Blog for SQL-SERVER & .NET
March 4, 2009 at 2:58 pm
how to put silde-show in asp.net webpage?…please send me c# code…
March 4, 2009 at 4:43 pm
Hi Jenny,
I would like to know more about your issue???? which kind of slide show you want to run in your C# application. Moreover, do you need it in web application or in c# application. do you want to run .PPS file or .PPT file. Please elaborate your issue more
March 5, 2009 at 5:44 am
Hello sir,actually my projct in asp.net with C# language…now i want to put slide show of picture in prjct so that slide-show images are .jpg or .gif or any other….not ant .PPT or .PPS file…
March 5, 2009 at 5:58 am
Hi Jenny,
There is no concept of slide show for JPG or GIF file. however, you can carry on your show with logical tweaking. You can bind pictured in gridview with paging and can change paging index with AJAX timer script but it is bit difficult. You can have another route you can make PPS file from power point and attach that slide show in your web form. that is a perfect solution for you I guess. by creating and attaching PPS in your webform, you can visit following links.
http://support.microsoft.com/kb/303718
http://www.dailydoseofexcel.com/archives/2004/12/27/show-powerpoint-slides-on-a-form/
http://stackoverflow.com/questions/217890/using-c-to-display-powerpoint
March 6, 2009 at 5:12 am
ok thank you….
November 12, 2009 at 9:15 am
Hi Ritesh, thank you for your article on linked servers. Although I have installed ACE 12.0, it is not listed under providers in SQL, have I missed an additional step, or is this an 32/64bit issue? Thanks….marcus
November 12, 2009 at 9:19 am
Hi marcus,
This link may helpful to you.
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/50b02072-35bc-4f69-9e67-7737c9464944
November 23, 2009 at 8:43 pm
Ritesh… Nice site.
Dig that caption. “Fight the fear of SQL” cool.
July 9, 2010 at 6:52 pm
Hello, i have read the information you have given for the delete multiple row. I pretty green in scripting SQL, so maybe you can help me. I have a database sql 2005 with 48 millions rows. The program send up date to the screen display and sadly it resend all the warning to the history file. I need to get ride of the message of auto expire from the old card.
So i start to write a script:
USE A6282010
DELETE FROM dbo.historyTable WHERE ActionDesc = ‘Auto Expire’
but as i have millions of line to delete, i know i will fill my hard drive. I recall you have a similar situation to solve. I know i have to create something more aleborate so i don’t fill all my hard drive with the temp db. Can you give me some help please?
Thank you in advance, Claude.
July 10, 2010 at 12:54 am
well, we can’t change the internal process of SQL Server, all I have is few suggestions for you.
1.) move your tempDB on seperate drive to reduce IO load
2.) before executing DELETE command, change your database recovery mode to “SIMPLE” if it is not. After DELETE you can change your recovery model back.
3.) good to execute this command in off hours.
4.) rather than deleting it in one shot, I would recommend you to do it in batch of may 10K or something and while this operation, keep an eye on disk space.
Do let me know if you need further help.
July 12, 2010 at 4:01 pm
Hello again, here another script with your suggestion of 10000. My back up is already in simple mode. Let me know if i missed something.
— A6282010 is my DB with the row to remove
— dbo.historyTable is my table
— ActionDesc is the field that i use to select the row to eliminate
USE A6282010
DELETE FROM dbo.historyTable WHERE ActionDesc = ‘Auto Expire’
IN
(
SELECT TOP 10000 dbo.historyTable
FROM MyTable
ORDER BY dbo.historyTable
)
SET ROWCOUNT 10000
DELETE FROM dbo.historyTable
SET ROWCOUNT 0
Thank you for your help!!
July 13, 2010 at 7:16 am
you can simply do something like this:
USE A6282010
DELETE TOP (10000) FROM dbo.historyTable WHERE ActionDesc = ‘Auto Expire’
December 7, 2011 at 6:39 am
Hello Sir,
I am Ashish Jain, I am new to database and i have a lot of interest in SQl, but i am not much aware with it. So please guide me for it. I wanna go for DBA preparation.
December 7, 2011 at 7:01 am
Hello Ashish,
There is no rocket science or short way to become DBA. As per my personal belief, Before learning DBA, you should have to be good SQL Developer which helps you a lot while you work as a DBA.
As of now, I could suggest you to read some good books, do more and more practical stuff in SQL Server and in any difficulty try to consult someone or try to solve it by yourself.
October 19, 2011 at 8:57 am
hi ritesh,
plz send me complete sqlserver notes to my mail…
October 19, 2011 at 9:18 am
what you mean by complete SQL Server notes?