Viewing 15 posts - 16,486 through 16,500 (of 39,970 total)
These are old views, for compatibility purposes. Don't use them.
sysusers has been superseded by sys.database_principals (http://msdn.microsoft.com/en-us/library/ms187328.aspx)
syslogins has been superseded by sys.server_principals (http://msdn.microsoft.com/en-us/library/ms188786.aspx) and sys.sql_logins (http://msdn.microsoft.com/en-us/library/ms174355.aspx)
Logins exist at a server instance...
April 14, 2011 at 3:12 pm
your code would have to
a) know which value was deleted
b) use something like this:
set identity_insert tb_bill on
insert tb_bill (bill_no, Product_code, Pro_desc) select 3, 'ABC', 'Third product'
set identity_insert tb_bill off
If...
April 14, 2011 at 3:07 pm
It's not this simple. The more I dig into things, the less I think I understand on memory pressure and the many ways to detect it.
First, if total (what you...
April 14, 2011 at 1:44 pm
Johan is correct, you don't want a function on the column value or you don't use indexes and must scan the table.
For the time, people often do this:
where mydatevalue >=...
April 14, 2011 at 1:28 pm
Snow
Still coming down in CO, this after I was out running in a t-shirt yesterday
April 14, 2011 at 10:52 am
Part of the problem is the <>, which can make you scan the entire table. Plus this can be a large commit, lots of log space required, and more. Typically...
April 14, 2011 at 9:26 am
Craig Farrell (4/13/2011)
Steve Jones - SSC Editor (4/13/2011)
April 14, 2011 at 8:41 am
NTBackup should work, though you need to test. If you haven't restored to another machine, you are potentially not doing your due diligence. If you cannot restore those backups when...
April 14, 2011 at 8:38 am
People like to think, so if you can make them apply knowledge without memorizing some answer, it's a good question. Hard to do well, and going off forum posts is...
April 14, 2011 at 8:28 am
Excellent advice from Jim above.
Service Packs fix things, but if you are not having issues with any of the things addressed in a service pack, then you don't need to...
April 13, 2011 at 6:21 pm
At one point we had a page peel there that opened and covered up the entire screen. I think it was from Quest, but it was definitely a $$$ thing....
April 13, 2011 at 6:19 pm
Realtime backup is going to require some work. And money.
There isn't a good way to do this in SQL 2000. you can do log shipping, where you restore your...
April 13, 2011 at 1:42 pm
Dwayne Dibley (4/13/2011)
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
As with most SQL questions -...
April 13, 2011 at 9:56 am
Since I need to track backups occurring, getting the size is simple and doesn't involve querying anything else. Seems simpler to me.
April 13, 2011 at 8:12 am
Nice question. It seemed clear to me also that you needed to account for different language or format settings.
April 13, 2011 at 8:10 am
Viewing 15 posts - 16,486 through 16,500 (of 39,970 total)