Raid5 is suitable for low cost and mainly read only applications as every write operation needs to calcul the parity to be written to the parity disk. Read operation can be fast because several spindles (physical disks) coud honour the read request.Raid10 is one of the most expensive RAID solution but ont of the best […]
2004-08-26
Hmm... I'm not sure I understood the question... are you asking how to mark all entries with duplicity, instead of leaving always one of them unmarked? If so, then try this:UPDATE e SET Dup = Yes FROM Employees e JOIN (SELECT FirstName, LastName, count(EmployeeID) FROM Employees GROUP BY FirstName, LastName HAVING count(EmployeeID) > 1) as […]
2004-08-26
If you are running the DTS package as a job, your SQL agent needs access to the operating system file. That means your sql agent must be started with windows authentication.
2004-08-26
I am backing up from one server to another server across the network. This has been working for months. Then on Monday night netweork backups began failing with an error like this:Processed 829088 pages for database 'molert', file 'molert_data_1' on file 1. [SQLSTATE 01000] (Message 4035) Processed 959 pages for database 'molert', file 'molert_log_1' on […]
2004-08-18
50 reads
Try this:Insert #temptablename exec <storedprocedure name> This will fill your temptable with results from the sp
2004-08-18
this works using the top method i have used a query to pick the top column from each table in the database - replace with your own table names and foreign keys create table #mytemptable ..... (add in table design here) declare @sysid int declare curs1 cursor for select id from sysobjects open curs1 fetch […]
2004-07-30
Hi rmizzar!It might be caused by what protocols that are used. I would try to first set the language to tcp/ip and if that does not work, to named pipes.If you are logged in on the server when you do this, use the Client Network Utility and go to Aliases tab. Type in the servername […]
2004-07-28
Why dont you use Agent to schedule and create the jobs?? I think you can get the TSQL for the jobs through this way, eg looking at properties of jobs etcAdam
2004-07-20
Not sure, folks, but I think the original question was about having temp tables with the same name running in stored procedures that run at the same time. The answer, Sahana, is that temp tables that start with a single # sign are session sensitive and a call, via EXEC, seems to also be considered […]
2004-07-20
Yes, #temp is refered to 3 times with three different aliases: 't1' & 't2' in the main query and 't' in the sub query. I suppose I could have used t3 as the alias in the subquery to make it more obvious.Peter
2004-06-25
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers