Viewing 15 posts - 2,896 through 2,910 (of 7,506 total)
Jon-538504 (8/30/2010)
C#
...
System.String.Concat("SELECT [Timestamp], [Subject], [EntryText] FROM [Article] WHERE [Timestamp] = '" +
calArticles.SelectedDate.ToString()...
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
August 31, 2010 at 1:08 am
the retro-question is : What's the datatype of your column [timestamp] ?
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
August 30, 2010 at 12:41 pm
- is your db-level 100 ?
- I should be possible to alter your column defs, but you must check the restrictions on sparse columns: http://msdn.microsoft.com/en-us/library/cc280604.aspx
BOL also states sparse as an...
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
August 30, 2010 at 12:38 pm
Seems to be a GUI problem.
Can you create the alert and its response manually via a TSQL panel ?
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
August 30, 2010 at 12:22 pm
smthembu (8/30/2010)
I have SQL Svr 2008 R2 & OS Windows 2008 R2 Std, I have created a backup maintenance plan to backup to one of our backup drive. Certain...
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
August 30, 2010 at 8:02 am
ps. (8/30/2010)
...
I created a test database in 2005 and tried to delete system SP but it did not allow me even though i have sysadmin privilage. Can't test it out...
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
August 30, 2010 at 7:54 am
I'm in favor for the options Leo.Miller provided :w00t:
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
August 30, 2010 at 7:48 am
as already stated: it depends.
If that column is used in where clauses, as a join argument, or order_by\group_by, it may be good to create an index for that column.
Should it...
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
August 30, 2010 at 7:44 am
Horrible screenshot to read :ermm:
Does your instance have an E-drive ?
Does that E-drive contain a path called "program files\microsoft sql server\Data" ?
Does your sqlserver service account have the needed auth...
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
August 30, 2010 at 7:30 am
jcrawf02 (8/6/2010)
Chris Morris-439714 (8/6/2010)
Brandie Tarvin (8/6/2010)
Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want...
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
August 6, 2010 at 7:21 am
Perry Whittle (8/6/2010)
wow this is really going off topic now, the OP only asked about cluster resources failing over from node to node 😀
I'm verry sorry for that :unsure:
but I...
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
August 6, 2010 at 6:53 am
Why don't you run the sproc locally ?
(have it push the data to your linked server using insert into linkedserver.linkeddb.linkedschema.linkedtable)
In general I'm not fond of using linked servers for...
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
August 6, 2010 at 6:26 am
here's a nice article at SSC http://www.sqlservercentral.com/articles/SQL+Server/70505/
It also mentions these great links on tempdb:
- Working with tempdb: http://technet.microsoft.com/en-us/library/cc966545.aspx
- troubleshooting performance: http://msdn.microsoft.com/en-us/library/cc966540.aspx#EEAA
These links provide good insight on why it is uses...
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
August 6, 2010 at 6:15 am
- Are you capturing deadlock info in your sqlserver errorlog ? (startup trace flag -T1222 )
- indeed your sproc cold have been written in a far more optimal way :hehe:...
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
August 6, 2010 at 6:02 am
Brandie Tarvin (8/6/2010)
Back to the point, Doesn't the data being in different places,...
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
August 6, 2010 at 5:11 am
Viewing 15 posts - 2,896 through 2,910 (of 7,506 total)