Viewing 15 posts - 5,146 through 5,160 (of 7,499 total)
and sqlserver is getting equipped with such a broad scale toolset,
it's getting hard to just know it all 😉
HTH
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
March 4, 2008 at 12:54 am
- as long as you don't forget to perform full maintenance after your restore, you should be fine.
- the data purity check
- reindex all tables
- sp_updatestats
- dbcc updateusage (0) with...
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
March 3, 2008 at 11:52 am
- if you don't need to use the linked server for direct querying, don't
define it, but switch to SQLDTS or SSIS !
IMO one should avoid linked servers because 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
March 3, 2008 at 5:30 am
I was asked this question in an interview...
My answer would be exactly the same.
IMO your interviewer was only interested in the fact how you would
play along with this kind...
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
March 3, 2008 at 5:24 am
how did you reattach the db ?
- using EM ? (may bite you in the back because it reads what's stated in
the mdf-file (still pointing to the old...
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
March 3, 2008 at 5:10 am
.... where Month(datefield)='mm' will probably not use an index because of the function you apply to the column.
- replace 'mm' by just the number (avoid implicit conversions)
- Can you switch...
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
March 3, 2008 at 4:59 am
first things to check:
- this query comes within brackets ... is it a kind of subquery or nested table expression ?
SELECT COUNT(DISTINCT ( RecordedCalls.ID )) AS CallsCount
...
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
March 3, 2008 at 4:53 am
y the way, my local machine is 2005, remote 2000.
That's another story :doze:
Did you apply http://support.microsoft.com/default.aspx?scid=kb;en-us;906954 at the sql2000 instance ?
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
March 3, 2008 at 4:14 am
no problem
Update T2
set LastnameFirstname = T1.au_lname + ' ' + T1.au_fname
FROM [pubs].[dbo].[authors] T1
inner join [pubs].[dbo].[TheOtherTable] T2
on T1.au_id = T2.theFKtoAuthors
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
March 3, 2008 at 3:32 am
SELECT [FirstName] + ' ' + isnull([MiddleName], '') + ' ' +[LastName]
FROM [AdventureWorks].[Person].[Contact]
SELECT [au_lname] + ' ' + [au_fname] as lastname_Firstname
FROM [pubs].[dbo].[authors]
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
March 3, 2008 at 3:28 am
did you enable "open rowset" on both instances ?
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
March 3, 2008 at 3:24 am
Since you need it realtime, your best option may be to define a linked server for the mysql server.
Check BOL.
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
March 2, 2008 at 8:15 am
You may want to check database triggers.
At SSC you can find examples and some articles regarding db audit, ...
e.g. http://www.sqlservercentral.com/articles/Auditing/62126/
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
March 2, 2008 at 8:13 am
just a short list:
- Gut feeling is not to install any datafiles in program file folders
- stay away from the boot drive or paging file drive with any datafiles
- What's...
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
February 29, 2008 at 8:15 am
in many cases the [not] exists with a correlated query will outperform a
left join with the where rightpart-table-column is null because
a [not] exists is performed using the (fast)...
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
February 28, 2008 at 9:21 am
Viewing 15 posts - 5,146 through 5,160 (of 7,499 total)