Viewing 15 posts - 16 through 30 (of 92 total)
I just renamed three of my servers, since their SQL server names were different from the windows server names. You have to restart the SQL server for the changes to...
May 18, 2004 at 9:15 am
Thanks to all.I am choosing Sachin's solution that was better than what I had come up with.
May 16, 2004 at 9:01 pm
If you have Kalen Delaney Inside SQL book there are some scripts in chapter 8 to estimate table sizes.
May 7, 2004 at 12:28 pm
What you have described used to be a big problem at our site too, where in the past users were each user had an account on the SQL server too,...
May 5, 2004 at 1:50 pm
Make the user member of "TargetServerRole" in msdb and that should do it.
May 5, 2004 at 1:26 pm
Munzer:
AFAIK, Remote server is used to run remote stored procedures only and these are only for backward compatibility. Linked servers are a superset of remote servers and can do remote...
May 5, 2004 at 9:51 am
I am not familiar with any correlation between number of columns and performance (assuming the design is normalized),
how ever keep in mind that the total row length for each row...
May 4, 2004 at 4:44 pm
sp_spaceused 'tablename' is known to report incorrect size (almost seems by design). More precise way is to use sp_spaceused 'table', true. This is especialy more important when you had just...
May 4, 2004 at 4:40 pm
I have seen my share of PAGIOLATCH_SH. Without getting into the details, this in essence is an indication of wait for disk resources to complete certain data transfer to...
May 4, 2004 at 4:29 pm
Run a perfmon job to monitor the tempdb growth. That would atleast tell you what time the growth is accelerating. Then you might schedule a sp_who or something of sorts...
May 4, 2004 at 10:00 am
My question was regarding casting / converting
20040503 83811 into the format of
2004-05-03 08:38:11.000
The solution in my mail with CAST works. I am looking for a better way !
May 4, 2004 at 8:35 am
If it is not working now, you have to explain where it is not working. Like,
what is it that you are trying to do with xp_cmdshell (is it BCP,...
May 4, 2004 at 8:25 am
Are the jobs and Schedule for the job "both" enabled?
May 3, 2004 at 9:38 pm
1. A regular domain user account should suffice.
2. This account should have "logon as a batch job" right. Besides it should have SQL Server access and all other permissions that...
May 3, 2004 at 9:36 pm
Simple recovery model still has to log the entire transaction, just like full recovery model. The only difference is that with the simple recovery once the transaction is committed, it...
May 3, 2004 at 9:28 pm
Viewing 15 posts - 16 through 30 (of 92 total)