Forum Replies Created
Viewing 15 posts - 391 through 405 (of 588 total)
-
RE: Partitioned tables
I would think the child tables would be partioned by whatever method you use to link them now to the main table (i.e. the FK). Just would be my natural...
-
RE: How To Use Wildcard in SELECT Statement (but not in WHERE clause)
Another solution could be to use a For Each loop in SSIS to do the restore, some rules would have to be set down for identifying which file is which...
-
RE: Does SQL Server do an implicit Trim() when comparing char() to varchar()
Agreed Jiri it can be quite tricky. Which is why I include the leading and trailing concatenation when I look at strings during investigations.
-
RE: The May Car Update
Hey I want a turbo diesel! Unfortunatly the only one available anymore is Mercedes S350 (I think that is the model number). We don't get fun diesels over here in...
-
RE: Almost Great Service
Part of the problem with MS was most likely that the person got another call as soon as you lost connection. At least that is my understanding from last time...
-
RE: How To Use Wildcard in SELECT Statement (but not in WHERE clause)
See my reply to you in the backup forum.
You could of course have the other SQL machine send an email that inserts that information to a table on the destination...
-
RE: Does SQL Server do an implicit Trim() when comparing char() to varchar()
For comparison they would be equal, spaces or no spaces. At least I think you are asking about the below:
declare
-
RE: How to modify default timestamp in .BAK filename
I think this discussion might be of interrest, includes my code, but also other peoples take on it:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=359034
-
RE: How to modify default timestamp in .BAK filename
Ryan,
somewhere on here I posted the scripts I use to backup my servers. With that you can configure the file names as you please. The way it is written emulates...
-
RE: The T-SQL Quiz
Actually at one place I worked my databases cured cancer! Well, they were used to control radiation machines!
In that environment, you bet we...
-
RE: The T-SQL Quiz
Doesn't surprise me at all that asking the difference between clustered and non-clustered indexes weeds out most people. But hopefully only peopel that are interviewing for a DBA position for...
-
RE: SQL Server 2005 Threads
I must not understand this question, because I can clearly see a bunch of SQL 2005 specific forums. But if you want to go to the beginning of them, use...
-
RE: Restoring the system databases
Just restore on top of them. Generally is faster than recreating the files (I think in Windows 2003 this might no longer make a difference).
If you have a complete filelevel...
-
RE: Error Messages with Severity 10 or lesser
Capture the value of @@error after the statement, then use raiserror to write it to the log.
-
RE: Parallel SQL Server?
I dunno Paul. I have had to call MS excatly twice in 12 years for help with SQL.
Viewing 15 posts - 391 through 405 (of 588 total)