Viewing 15 posts - 181 through 195 (of 271 total)
I agree with David on this i would start with Kalen Delaney's book Inside SQL Server but the best buys you can make are the three Ken Henderson books the...
October 1, 2005 at 4:04 am
In SQL Server 2005 there is a tool called Business Itelligence Studio where you create your reports, Analysis Services stuff and SSIS bits so you no longer need to buy...
September 29, 2005 at 4:36 pm
This articel by Ken Henderson on memory management should explain what you need to know.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_01262004.asp
hth
David
September 26, 2005 at 4:48 pm
oops
sp_dropserver old_name
GO
sp_addserver new_name, local
I can't even cut and paste today!
hth dave
September 8, 2005 at 2:57 pm
Yes
sp_dropserver old_name
GO
sp_addserver new
hth dave
September 8, 2005 at 2:56 pm
I had a similar issue as I too back up all our sql server databases to a central location on the network accessed by a unc path.
I initially did the...
August 17, 2005 at 2:49 pm
My test machine is 2003 sp1 and sql server 2000 sp4 and I have installed reporting services on it with no problems it's been running like this for a while...
July 28, 2005 at 7:44 am
Oops didn't quite read your post correctly no you don't need to drop them you can use one of the two dbcc commands mentioned in previous post
David
July 28, 2005 at 6:53 am
The main diffrenec is that dbcc dbreindex is an offline operation whereas dbcc indexdefrag is an online operation.
However dbcc indexdefrag will skip any locked pages while it is working so...
July 28, 2005 at 6:51 am
My understanding from Ken Henderson's blog and is that this will still be an issue in 2005 but by the sound of slava's blog maybe not as bad hmm looks...
July 28, 2005 at 12:44 am
As far as I can remember if you don't have battery backed up disk controllers you can suffer from a torn page if you suffer a power outgae in which...
July 26, 2005 at 6:19 pm
If you are using windows 2000 or 2003 this procedure which uses cdosys will work if you actually need to use cdonts because you're still on Nt you'll just need...
July 25, 2005 at 3:35 pm
ou have to redploy a lot of reports for them to work correctly
hth
Dave
July 22, 2005 at 2:52 pm
A reason you may get this is that when you install reporting services it uses the anme of the server to create a deafult name for the web site. If...
July 22, 2005 at 12:33 am
If you apply SP2 you can print directly from IE.
hth
dave
July 22, 2005 at 12:19 am
Viewing 15 posts - 181 through 195 (of 271 total)