Viewing 15 posts - 3,466 through 3,480 (of 7,499 total)
start with the Upgrade advisor for sql2005 !
It will point you to potential issues with your db.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 17, 2009 at 2:56 am
- if a filegroup gets filled up and cannot auto extend any files , you'll get an errormessages stating "filegroup full".
So you nolonger can add data to it, rebuild indexes,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 16, 2009 at 2:37 pm
- also, with these ndf files, it is best to know if they are all allocated to a single filegroup or not. Having multiple files allocated to a filegroup would...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 16, 2009 at 1:11 pm
As always, it depends 😉
- For small files, rarely requested, you could use a dbmail solution and mail the query result as attachement.
- another alternative is to use a sqlagent...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 16, 2009 at 3:31 am
2 things:
- there is a faulty path in your script !
SET @FileName = 'd:aveen.txt'
Should be SET @FileName = 'd:\aveen.txt'
- has your sqlserver instance service account been granted read access to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 16, 2009 at 1:51 am
By default, there is no order in a set !
1 things you can do:
- Add an order by clause to your select statement.
Keep in mind order by follows the order...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 16, 2009 at 1:44 am
for sure you can define your dns alias like "OurVeryNiceVirtualSQL" but to get to the actual instance (you may have many on your nodes), you'll also have to provide the...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2009 at 12:00 pm
This will for sure get you on track : http://www.sqlservercentral.com/scripts/31797/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2009 at 11:16 am
I depends 😉
$$$ caused me to have to build my own inventory solution, providing simple history information for instance settings, databases, tables, indexes and volumes.
And a good lesson it has...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2009 at 4:22 am
satishthota (9/15/2009)
Create Table emp(empid int,ename varchar(30))
Insert Into emp values(101,'A')
Insert Into emp values(102,'B')
Insert Into emp values(103,'C')
and I had created following view on emp table
Create View Vw_EmpDet
as
Select empid,ename...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2009 at 3:46 am
please read this for your options with sql2008 editions and upgrade options:
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2009 at 3:31 am
- You can post the results of the DBCC checkdb if you want to.
- The main reason why you cannot just switch to full recovery, run a logbackup and...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 14, 2009 at 5:49 am
- with simple recovery you can only go to the previous full backup ( and if you have a differential backup, you can also apply that).
- how did you...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 13, 2009 at 2:19 pm
:hehe:
declare @tmp table (UserName varchar(128) not null, EmailAddress varchar(128) not null primary key, TsRegistration datetime not null)
Insert into @tmp values ('alzdba', 'alzdba@dono.com', '2001-04-01 18:00:00.000')
Insert into @tmp values ('alzdba', 'alzdba1@dono.com', '2002-04-01...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 11, 2009 at 8:18 am
For a couple of years I've had the pleasure to attend SQLPass in Seattle, Denver and Grapevine.
If you do the math on costs, you'll see the cost may even be...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 11, 2009 at 4:02 am
Viewing 15 posts - 3,466 through 3,480 (of 7,499 total)