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 ,...
Periodically my SQL 2005 snapshot publication database starts to grow it's log
file without truncating.
- The recovery model is 'simple'
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...
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
I have a question on Distribution database.
There are couple of tables MSrepl_commands(more than 20 millon rows) and Msrepl_transactions(more than...
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...
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...
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...
How do we write a query for something like this
Quarter month amount
------- ---- ------
1 1 10
I have a table as shown below
i need a query that will display sum of col1 in the rage...
Is there anyway around to use diffenet destination table every months without opening & changing the table name in the dts package.
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.