Viewing 15 posts - 35,686 through 35,700 (of 49,552 total)
hydbadrose (11/23/2009)
The function name I had in caps and the system has in lowercase.
That'll only make a difference if you've installed the server with a case-sensitive collation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 12:28 pm
You can have as many AFTER INSERT triggers as you like. It's the INSTEAD OF triggers that are limited to one per operation.
What's that trigger supposed to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 9:27 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 9:26 am
Got a backup? Ask your client. It's the best way to fix this.
If not, try hacking the DB back into the server. See the procedure here: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
If you go that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 9:10 am
If it does, then create a new column with the varbinary type. Update it from the varchar with convert, then drop the varchar column and rename the varbinary.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 9:08 am
Grant Fritchey (11/23/2009)
Yep. Gail nailed it (shocking I'm sure).
Just finished writing a blog post on 'optimal' join types. Virtually a copy-paste from blog to forum.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 8:51 am
sanya.ibrahim (11/23/2009)
Sorry, I forgot to write the "from" clause in the code I wrote here in the forum. The actual sp has the 'from' clause.
Then post the actual sp.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 8:34 am
First thing to note is that 1 row in each table is not enough for any meaningful conclusions. You really need a couple hundred at least.
As far as I'm aware,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 8:27 am
ALTER TABLE <Table Name>
ALTER COLUMN <Column Name> <New type information>
See Books Online for full details. Look under ALTER TABLE
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 7:39 am
I'm not much of a steak fan (or beef in general much), but I think I'll be trying out the steak recipe soon.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 2:13 am
Two very different features. Both really for working across servers, thought it's possible to replicate within an instance
Start here:
Mirroring http://msdn.microsoft.com/en-us/library/bb934127.aspx
Replication http://msdn.microsoft.com/en-us/library/bb500346.aspx
Once you're read through that lot, if you still have...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 2:05 am
Take a look at this series: http://www.sqlservercentral.com/articles/Indexing/68439/
Columns specified as include are ones in the select clause, but not used in where/join. Don't trust the missing index dmvs totally. Test out...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 1:26 am
Two print copies, both signed by various authors/editors, one for me one to be given away at a usergroup meeting sometime next year.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 1:20 am
y.koteswarrao-652921 (11/23/2009)
yes, recently i have taken full database backup and i missed .mdf file,how to recover it?
Can you explain in more detail what you've done, what happened and what you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 1:19 am
Restore the latest backup of MSDB (perhaps to a test instance), script out the job, apply the script on the server where the job was deleted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2009 at 1:17 am
Viewing 15 posts - 35,686 through 35,700 (of 49,552 total)