Viewing 15 posts - 331 through 345 (of 535 total)
The hardest exam was 70-443. The only way I could finish it in time was to read each question first and scan the case study to find the information...
July 3, 2008 at 4:51 am
Prathyusha (7/1/2008)
yeah i checked that page out earlier it shows the cpu time from the entire instance i want it for each dtabase...like in the cpu being utilized by that...
July 2, 2008 at 3:31 am
yes you can, just as you would with a single mail address...
@recipients = 'DBAGroup@MyCompany.com'
June 30, 2008 at 9:51 am
Yes all schema changes are copied over, just remember that DB Mirroring is on the database level, so any logins, instance level DDL triggers and certicates/master keys etc will not...
June 30, 2008 at 7:27 am
Maybe not the best way, but the following code works as long as you stick to just having the 6 months revenue....
create table rev
(
id int identity(1,1),
Rev money
)
go
...
June 30, 2008 at 2:53 am
In management studio, right click on the database and go to tasks, generate scripts. Select the tables you want to script and thats about it. You get options...
June 30, 2008 at 2:17 am
Post this in the Business Intelligence forum, you probably have a better chance of getting a response.
June 30, 2008 at 2:04 am
I use this following code to find any long running spids and kill them off. you could easily tweak it to email you about the spids rather than kill...
June 26, 2008 at 9:47 am
Good question, and im not 100% sure of the reason why. However, if you use the following code the select statement works fine
declare @dec varchar(50)
set @dec = ( select...
June 26, 2008 at 9:35 am
My advice would be try and get a job on application support where the backend is sql and they will let you train up in SQL. that way you...
June 25, 2008 at 10:08 am
2cams (6/23/2008)
Passed my 70-443 Exam 2day 😎Going to takkle the 70-444 a little bit later on this year 😛
Congrats 🙂 i am doing the 70-443 exam in 2 weeks...
June 25, 2008 at 9:57 am
vijay (6/25/2008)
This May Stop the Jobs base on the logic i build.But again how do i restart it again??
well if its stopped (failed) then the status will say so, and...
June 25, 2008 at 8:02 am
the way i get round this sort of thing is to look at the sysjobhistory (i think thats the table) and see if your job is in there after 10...
June 25, 2008 at 7:55 am
drop all the subscriptions first and then try again.
June 25, 2008 at 6:56 am
I believe this is when parallel processing is used and sometimes the SPID does block itself, although usually only for a very small amount of time before it is released....
June 25, 2008 at 5:05 am
Viewing 15 posts - 331 through 345 (of 535 total)