Viewing 15 posts - 1,486 through 1,500 (of 7,502 total)
Don't put a function on your tables column ! (it ruins index usage !)
do the function on the foldable calculated formula on getdate !!
and consider putting an index on...
January 5, 2012 at 3:53 pm
Please allow me to point to a very interesting project at codeplex:
Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server[/url]
pre-configure windows, install sql, post install scripts, ....
January 5, 2012 at 11:09 am
Do you need to take DST (Daylight saving time) into account ? ( search SSC for solutions )
Just to remind some pitfalls ...:Whistling:
January 5, 2012 at 11:02 am
and please keep your datetime column in datetime datatype as long as you can !!
select dateadd(mm, datediff(mm, 0, thedatetimecolumn), 0) BeginOfMonth
, theuser
, count(*) nVisits
from ...
where ...
group by dateadd(mm, datediff(mm,...
January 3, 2012 at 12:16 pm
In sqlserver, you cannot have a child without having a parent, at least if the FK constraint is in place !
Leave it in place !
Just double check you load the...
January 3, 2012 at 12:11 pm
bwoulfe (1/3/2012)
Yeah, uniqueIdentifier is what you're looking for. I generally try to avoid them but I'm sure they have their uses.
+1
Choosing the correct datatype does matter !
Just keep in...
January 3, 2012 at 12:08 pm
That's a nice present, isnt' it :sick:
have a look at Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out
January 3, 2012 at 12:03 pm
For only the FK info you can use
sp_fkeys 'schema.childtable'
but that doesn't publish datatype nor length
January 2, 2012 at 11:22 pm
Keep in mind my comments are not that devs are by definition not suited to handle sqlserver stuff !
I know devs who do their stuff very well with regards to...
January 2, 2012 at 10:23 am
It depends of the experience of your dev teams with regards to :
- data analysis
- data documentation ( especially uniformity of data declaration )
- normalization process
- dealing with large...
January 2, 2012 at 12:57 am
did you look at the scripting of SSMS ?
or
have a look that the information_schema views ...
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_SCHEMA = 'Person'
order by TABLE_NAME, ORDINAL_POSITION ;
January 2, 2012 at 12:48 am
Whatever you do, make it an Inline Table Valued function !!!!!!!
( and use it with cross apply )
That is, if you would like it to perform.
Test it, test IT !
December 30, 2011 at 1:53 pm
pkrudysz (12/29/2011)
ALZDBA (12/29/2011)
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- Cool.
ALZDBA (12/29/2011)
December 29, 2011 at 7:53 am
e.g.
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- granting auth at windows level ( e.g. to push backup files to a safe...
December 29, 2011 at 12:50 am
toddasd (12/28/2011)
Dev (12/28/2011)
george sibbald (12/27/2011)
logicinside22 (12/27/2011)
thanks folks for nice reply . I did with Detach and Attach Option and it looks good now.
can I then recommend that you...
December 29, 2011 at 12:01 am
Viewing 15 posts - 1,486 through 1,500 (of 7,502 total)