Viewing 15 posts - 14,656 through 14,670 (of 26,486 total)
As we can't see from here what you see from there, a little hard it is to tell you exactly what you need to change.
April 1, 2011 at 12:51 pm
Not really.
In the message sent to SB you include the datetime it is sent. The reader in SB uses the difference between now (when it reads the message) and...
April 1, 2011 at 11:47 am
Service Broker is another alternative as well for this application. You may want to read up on it in Books Online.
April 1, 2011 at 10:24 am
Glad I was able to help.
March 31, 2011 at 3:57 am
You can also use the iTVF just like a table (a paraterized view if you like). It all depends on what the iTVF does and is written.
March 31, 2011 at 3:50 am
If you mirror the data warehouse database (which you noted would require using the full recovery model), be sure to run a transaction log backup when the ETL processes complete....
March 31, 2011 at 3:28 am
NoRecovery leaves the database in a state ready to restore the next log back. There is no access to the database allowed.
Standby will put the database in a read-only...
March 31, 2011 at 3:20 am
Lookup creating a SQL Server Agent Job in Books Online. This is where you will create a job that will run your stored procedure on a scheduled basis.
March 31, 2011 at 3:11 am
Rebuilding an index on a table will update the statistics for that index, yes.
March 31, 2011 at 3:10 am
I just noticed that you are doing this for mirroring the database. I'm not a database mirroring expert, but I am pretty sure both servers need to be running...
March 31, 2011 at 3:03 am
THE-FHA (3/31/2011)
but cant you jst upgrade 10.00.4000 to 10.50.*** without having to upgrade the entire server or that would still give issues? Isnt there a CU for this to...
March 31, 2011 at 2:58 am
First, here is a delimited split function. If you search this site you will find other versions which may have better (or worse) performance. Please note the absence...
March 31, 2011 at 2:53 am
THE-FHA (3/31/2011)
Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008...
March 31, 2011 at 2:10 am
Here is another version of the UPDATE statement using a table (dbo.updCustomers in the code below) with a list of customer numbers to update:
update dbo.tmpCustomers set
ChargedYN...
March 31, 2011 at 2:06 am
Hard to know what to tell you as we can't see from here what you see. It would help if you would provide the DDL for the tables involved,...
March 30, 2011 at 12:58 am
Viewing 15 posts - 14,656 through 14,670 (of 26,486 total)