what is the main difference between constraints(like primary key etc..)& joins?2 3872
What are the types of backup and tell me the difference between full and differential backup?4 9662
Wht is Stuff in sql ser2 2706
how to get 25th row in any table in sqlserver can u tell me syntax8 7032
How to find the last update record in SQL Server?4 13405
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...7 6099
How to trouble shoot if unable to connect SQL Server
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Which is the best place or learning center for MS SQL?????In Bangladesh?????
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
how to overcome kernel isssues
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is best institute to Learn DotNET And SQL in chennai?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
wat wil hapn if we give the both read and deny read permission to user?
how can you attach more than 20 ldf files in sql server