Viewing 15 posts - 91 through 105 (of 2,903 total)
Thanks. I think that's what we are going to have to do for the initial cutover. We can do that manually (run sp_help_revlogin and then run it on...
November 4, 2015 at 2:26 pm
SQL Server will not recognize the alias because it doesn't exist yet. It only exists once the value is selected from the table and since all the data is...
October 29, 2015 at 2:55 pm
GeorgeCopeland (10/28/2015)
October 29, 2015 at 2:47 pm
Jeff Moden (10/26/2015)
SQLBill (10/26/2015)
October 28, 2015 at 3:52 pm
The way I would determine which to use (Active or Inactive) would depend on how I am going to query the data. I use "pseudo code" to determine what...
October 26, 2015 at 3:03 pm
Sites means different locations. That can be as far away as servers in different countries, or as close as two servers right next to each other.
-SQLBill
October 1, 2015 at 3:57 pm
The IT minion should have to buy the rounds. Personally, it sounds like a two tequila shot and one beer day to me.
-SQLBill
September 24, 2015 at 1:36 pm
jaskew 10191 (9/17/2015)
Tried that once. Got a huge raise by staying, then fired after the project was done two months later.Don't trust your boss.
I know someone that had something similar...
September 18, 2015 at 9:57 am
Any triggers on that table? Specifically any FOR DELETE triggers? How about foreign keys causing cascades on delete?
-SQLBill
September 8, 2015 at 10:27 am
Brandie Tarvin (9/4/2015)
One business unit wants to know why production report X was timing out, so I went...
September 4, 2015 at 10:41 am
TomThomson (9/3/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
So for AMAZON this guy is going to use a 6 character password? And for Yahoo he'll have a 5 character password?
It...
September 3, 2015 at 3:52 pm
Is there a trigger on CSV_Details that is fired when there are deletes? If so, that is most likely the culprit.
Are there FKs to other tables that have ON...
September 2, 2015 at 9:12 am
exec sp_msforeachdb is used to run one or more commands on all databases (For Each DB)
Just run this:
Insert into Track (RunDate,Dbname,file_Size_MB)
select
getdate() as RunDate,
DB_NAME() AS DbName,
...
September 2, 2015 at 9:06 am
Check your code for reindexing....does it use SORT_IN_TEMPDB?
-SQLBill
September 1, 2015 at 2:58 pm
Lowell (8/31/2015)
SQLBill (8/31/2015)
Trick question isn't it?UNIQUE constraint: used to "...make sure that no duplicate values are entered..." So you can't have duplicates.
-SQLBill
no, it's a classic question on...
August 31, 2015 at 3:50 pm
Viewing 15 posts - 91 through 105 (of 2,903 total)