Hi, If I have the following data how can I use the PIVOT statement to return it like team member -------------------- ERP Jack ERP John ERP Mary CRM...
Hi, When using table partitioning where is the metadata which shows which partitions have had new data or which partition has had data removed. I...
Hi, Please can someone advise if the following is possible? I have a production and a dr site with the same database on. If I have a table which is...
Hi All, I'm trying to insert some records from one table where they have corresponding rows in another. I have tried a couple of approaches. Please...
I have a process which executes a number of times per day. when it runs a snapshot is created and a bunch of select statements are executed against...
Apologies if this is old hat. I was having a problem this morning with a production db. I was unable to run UPDATE STATS for a certain table. Which...
Hi, I was wondering if anyone had any suggestions for duplicating data in a column? What I want to do is update a column on a table i.e....
I would like to do the following and am struggling. Please can someone tell me if I am flogging a dead donkey? I have DB1 that has one table that...
Hi, Is it possible to sysadmin from seeing certain data? I have been asked to come up with a method where managers can only see employee salaries at...
Hi, Occasionaly we get the following error on one of our servers: WARNING: Failed to reserve contiguous memory of Size= 12713984 I am currently...
Hi, Does anyone know how to capture the output from DBCC SHOW_STATISTICS ..... I have tried inserting the output using the following:INSERT INTO...
Hopefully the title should wet your appetite. I am interested in methods people might use. We have a multithreaded process which on completion...
Apologies if this is a silly question. Please can someone tell me about memory limitations: If I have a SQL 2K ENT on a Windows 2003 ENT Cluster....
Hi, I have spent some time searching the web and don't seem to be able to come up with a definitive answer. Is it possible to accurately measure...
Hi, I would really appreciate peoples input on the following. I have just setup logshipping on my test db server whch is a 4 way dual core with HT,...
Hi, We have a customer who is going to have ODBC access to a near real time copy of their on-line database. I have been asked to suggest a way to...
Hi, I have had the following query running for 2.5 hours: insert into base.dbo.customerhierarchy select * from test.dbo.customerhierarchy Tis...
I have a job with a number of steps. Some of the steps call other jobs using 'EXEC msdb..sp_start_job'. If any of the steps fail the job should quit...
I am trying to set up a linked server to an Oracle server as I would like to migrate the DB to SQL Server. I am able to add the Linked server...
Apologies if this is a silly suggestion. If I have two databases one made up of multiple files and filegroups is there any method of backing up,...
Separate names with a comma.
