Search results for query: *

I have come across a rather odd problem with partitioned views and was hoping that someone could shed some light on it. If you have, for example, 4 base tables for each quarter's sales data and these are partitioned using a datetime field that is part of the primary key and using the constraint...

My thanks to you all for a quick response. The actual sp_executesql was used by a outsourced developer creating a web application and we were astonished by the speed at which it executed a simple select statement and were just seeking confirmation that it should behave like this. I thank you...

We are currently having an issue with using sp_executesql. When you run a basic query such as select top 1000 * from <table> where surname like 'Smith%' it returns in 14ms as you would expect. Now, as was advised on many sites, if this query is going to be reused on a regular basis but with...

Hi. We are about to migrate a sql7 database onto a new sql2000 cluster and are wary about orphaned login issues within sysusers. Now I ahve found many thing about how to fix SQL Server logins using sp_change_user_login (I think that was it!) but there doesn't appear to much on what to do about...

At work we are currently having problems replicating some large tables over to our Warehouse (average is about 28mil rows) It copies the data over fine but seems to fail on creating the index as the row count on both tables are identical. It fails with the error &quot;The process could not...

Why do I have such an ability to over complicate things!! THanks James that's so much more sensible than my idea!

I have been tasked to set a job running that will actively monitor out of hours users and record what they were doing. It is my intention to try and throw the output of DBCC INPUTBUFFER into a table for any non-system users that are actually executing something. The problem comes from the fact...

Thanks for the help all. In the end I just used a script to auto-populate a batch file that was scheduled to run every morning as a temporary solution but I think that Dky1e's idea would be more suitable as it tidies itself up afterwards and is without repitition should the job fail. Thanks again

Hello. I have recently started using transact SQL and have come across a small problem. I'm trying to launch a list of Perfmon files from within a cursor using xp_cmdshell. The problem is that it appears to wait until the launched application has terminated before it will cursor onto the next...