Hi all, After restarting the production server, our stored proc. seems to executing at the normal speed what we are see in Dev & UAT servers....
Why does Count(*) and sp_spaceused rows count is different for some tables? I used Dbcc updatausage to corrects pages and row count inaccuracies ,...
Hi Periodically my SQL 2005 snapshot publication database starts to grow it's log file without truncating. - The recovery model is 'simple' - There...
I have a column reportdefn defined as xml in a table AdhocPivotTableReport<br />Values in the table is as shown below:<br /><br /><xml xmlns<img...
Hi , I moved the tempdb data & log file to different location from where it was installed & then i copied the data & log to that destination...
I have table with data as shown below id entityid rolecodeid 5965605140 5965605240 5965605340 5965605440...
I have a question on Distribution database. There are couple of tables MSrepl_commands(more than 20 millon rows) and Msrepl_transactions(more than...
Hi all, I am trying to configure a Transactional replication using remote distribution and pull subsriber. I was able to successfull configure...
We Moved the database from sql2000 to sql 2005 . From then on we are having locking problme. As of now , we are thinking to change Transaction...
Hi , If i backup my local analysis services & restore it on dev server is that going to work. Only difference between local server & dev server is...
Hi, While processing the cube in the server i got a error msg. I didn't get the msg when i processed the cube on my local server. rrors in the...
I am trying to write sql for giving grant permission on view defn for all stored procedure. Can you tell me wht i am doing wrong. SET NOCOUNT ON...
Hello everyone, How do we write a query for something like this Quarter month amount ------- ---- ------ 1 1 10 1...
Hi, I have a table as shown below col1 col2 1 16 2 24 3 28 3 32 5 40 6 42 i need a query that will display sum of col1 in the rage...
Hi, Is there anyway around to use diffenet destination table every months without opening & changing the table name in the dts package. Since we...
Hi , I have sqlserver 2000 Database. Today something happened to our hardware & from that point i was not able to access the DB. Error msg we...
Separate names with a comma.
