1,164 reputation
67
bio website SankarReddy.com
location
age
visits member for 5 years, 6 months
seen Oct 26 '13 at 6:51
Sankar is a Database Engineer/DBA currently working for FunMobility, a mobile media entertainment company. He has been working with SQL Server from 2003 in a variety of roles including development DBA, Database administrator, Report writer and datawarehouse developer. Currently he works with high traffic OLTP and Tera byte datawarehouse systems. Sankar spends most of his free time at MSDN social forums answering questions.

Sep
24
awarded  Autobiographer
Jun
1
awarded  Yearling
Jun
1
awarded  Yearling
Jun
1
awarded  Yearling
Jun
20
answered SQL Server Delete - Ran out of disk space
Jun
17
comment SQL SERVER Query result performance question
If you have enterprise edition then you can use ONLINE flag to build the index online otherwise try reorganizing the index (which is slow, and NOT as effective as REBUILD).
Jun
17
comment SQL SERVER Query result performance question
Caching the data pages is a server concept and it is done automatically by SQL Server whether the request is coming from the server or from a different client. How simple is the query and can you share the execution plans from both?
Jun
17
comment Server restarted when I take database backup in SQL Server 2008?
On these 2 databases run the following and share the results. DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS
Jun
17
comment SQL SERVER Query result performance question
What happens if you run the same query for second time from your computer. Does it still take 35 seconds or runs quicker?
Jun
17
answered SQL SERVER Query result performance question
Jun
17
answered Backup and Restore Strategy in sql server 2008
Jun
17
answered Using a subscriber database as a backup
Jun
5
comment Store a table in a memory
When u execute a stored proc, the SQL Engine will work for you and put that table in memory if it is NOT already there. Again when u make an update, SQL server will put that data in memory first and will stay there until a CHECKPOINT happens/lazy writer kicks in.
Jun
5
comment Store a table in a memory
select a1, a2, a3, a4, a5, a6, a7, a8, a9, a10 from TableName
Jun
5
answered Store a table in a memory
Jun
2
comment How to see when a SQL Server 2008 Certificate Object Expires (& other properties)
NP. Glad it was helpful :-)
Jun
2
awarded  Yearling
Jun
1
answered How to see when a SQL Server 2008 Certificate Object Expires (& other properties)
May
26
answered Can Accpac be used with Windows authentication for SQL Server?
May
26
answered SQL Server mirroring - how many sql mirrored servers can you have?