Hi i see in the sql logs very often this kind of massages poping up Just like below and not sure what they meant because server or Database not...
Hi SOme one can provide advantages and disadvantages in implementing Schemas in prod environment.
Folks i was hearing timeout errors issues suddebly since one week ,but i did not find any errors in sql log these time out are kind of irregular...
Hi folksi have changed the sql server name Drop and add server script and it returns correct name when i do sp_helpserver namebut if i do @@server...
we are having some issues with one of my server.which is hosting the Named instance Connecting from workstations.to the named instance is erroring...
i see this error in the sql logs and i cannot log on to the server using qualified name but i can log on using servername and port number and also...
I Found the below error and all my maintenance jobs were failing with the same error. Do any one have any clue on it. help is much appriciated....
Hi guys i found very funny situation when ever i run a select or update statement contaioning three involved in joining when run sp_who2 i find in...
is it required maintanence plan like Backup optimizations and dbcc checks at all? Because it stores only temp data and session informatio.
<P mce_keep="true">Hi guys </P><P mce_keep="true">i was off way successfull in moving the SYSTEM Databases from one drive to other drive on the same...
Hi got kind of situation, we have one sql user on the database now we need to figureout who is actually using it because we plan to delete it but...
I Found that dropping the user from database , erroring out like cannot delete the user because the objects owned by the user. i could not...
Hi Guys I Was on the Move of changing the Database collation from Windows to SQL. In that process i have found many Columns Declared column level...
Hi Guys Can some one provide the best practices to implement Partitioning in the SQL 2005. Right now in our environment we are not using it . if we...
MS SQL Server 2005 Standard Edition Supports Analysis services or what SQL 2005 editions supports ANALYSIS SERVICES.
Hi all i got in a situation like this, need to install Analysis services on existing Sql Server which is already in the use. what are possibilities...
hI I am getiing below error while i am doing restore . i know i have more than 50 gb of space on disk but my mdf size 5 gb and ldf size 6 gb .total...
Hi we are doing log of database migrations , so it is making lot of time and pain while restoring users back to the databases what is the best way to...
Hi i have very big table in rows more than 100 million and also many check and forien key constraints planning to create non clustered index, what...
Hi it seems to be some confusion i have a backup file with size of 6 gb on the disk as it is native back up no compression . now real confusion...
Separate names with a comma.
