Viewing 15 posts - 3,946 through 3,960 (of 7,499 total)
AShehzad (3/2/2009)
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, 2009 at 4:31 am
GilaMonster (3/2/2009)
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether it'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
March 2, 2009 at 4:09 am
Keep in mind tempdb is on of SQLserver's working horses !
If you ensist on quering the catalog for temp objects,
keep in mind SQLserver names them as it pleases.
If there is...
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, 2009 at 3:18 am
Column names are a fixed item in sql, so
to do that you would have to generate dynamic sql:crazy:
or use a form of pivot function.
Declare @sqlstmt as varchar(500)
Set @sqlstmt = 'select...
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 1, 2009 at 7:27 am
has the clr proc been granted external access ?
Personally, I wouldn't put that kind of stuff in a trigger.
A trigger is in process context, so if the trigger fails, 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
March 1, 2009 at 7:15 am
SSMS / database / backup GUI presents the last known filename that has been used to create a backup.
As you've stated, what's in an extention. It can be anything.
If 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 1, 2009 at 7:10 am
Sqlserver raises events when a queue get disabled.
Check out "CREATE EVENT NOTIFICATION" in books online !
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, 2009 at 6:04 am
- tempdb is re-created every time sqlserver gets started !
- there is no need to grant on tempdb !
everyone is allowed to create #-tables !
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, 2009 at 6:00 am
Check out create database or Alter database in books online !
e.g from BOL
ALTER DATABASE AdventureWorks
MODIFY FILE
(NAME = test1dat3,
SIZE = 20MB);
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, 2009 at 5:54 am
Here's another forum thread stating some sequences and actions:
http://www.sqlservercentral.com/Forums/Topic655130-146-1.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
February 27, 2009 at 1:08 pm
Keep in mind you also need to backup master and msdb !
just put the script in a file e.g. fullsystembackup.sql
Then create a SQLExpress_fullsystembackup.cmd file containing :
cd /d yourdrive:\thescriptpath
sqlcmd -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 27, 2009 at 12:57 pm
As stated above, you can use management studio to perform the action.
However, more interesting is to let SSMS generate the SQL to complete the action.
Doing so, you'll see SQLserver encapsulates...
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 27, 2009 at 12:49 pm
Check out the execution plan of both queries and execute them both a couple of times (so data will be in memory).
(SSMS Querypanel Ctrl+M or Menu Query topy "Include actual...
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 27, 2009 at 12:42 pm
😉
What always tends to bring the confusing with charindex/patindex is that is has its arguments in another order then the replace function.
Whenever I need to use anyone of those, F1...
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 27, 2009 at 5:40 am
declare @charpos int
declare @searchterm nvarchar(max)
SET @searchterm = 'blood and sweat'
set @charpos = charindex('and', @SearchTerm)
IF (@charpos = 0) --Check to make sure string position was found
BEGIN
...
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 27, 2009 at 5:14 am
Viewing 15 posts - 3,946 through 3,960 (of 7,499 total)