Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
.net android asp.net asp.net mvc azure backup bigdata book business intelligence c# community continuous delivery database denali excel gotcha how to indexing java mongodb mvc music store nancy nhibernate nosql performance powershell security silverlight sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali ssis ssms ssrs structuremap syndicated t-sql teamcity tip unit testing vb.net visual studio 2010 windows 7
- SQLDenis (597)
- Christiaan Baes (chrissie1) (545)
- Ted Krueger (onpnt) (345)
- Jes Schultz Borland (grrlgeek) (146)
- Eli Weinstock-Herman (tarwn) (130)
- Alex Ullrich (52)
- George Mastros (gmmastros) (46)
- Koen Verbeeck (44)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (27)
- David Forck (thirster42) (22)
- chopstik (20)
- Kevin Conan (18)
- Rob Earl (14)
- thatrickguy (12)
If you look at the sys.sysobjects view, you will see an xtype column listed Object type. Can be one of the following object types: AF = Aggregate function (CLR) C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L…
There are 13 new videos on channel 9 posted about SQL Server. The non-marketing videos (by engineering PMs) give customers peek into the goals and visions why certain SQL Server features were decided and implemented. Below is a list with a little blurb…
This post is based on a question I answered earlier today, someone wanted to check all columns that allow NULL for NULL values in all tables. The reason people might want to do this check is that they want to make all the columns not nullable in a database (after all we all know that developers hate NULLs).
The Stored Procedure below is based on the code that George Mastros wrote for the following blog post:
I have a bunch of processes that run at then end of the day. Some of these processes are configured dynamic since table names, server names, database names and a whole bunch of other stuff might change. SO you migh have a (over simplified here) table l…
This is just a quick blogpost that will show you how you can use T-SQL to get the command line startup parameters that were used to start SQL Server. Before I start I want to warn you that you do not try NET START and NET STOP on a production server since you might mess stuff up big time!!.
In order to start SQL Server with parameters we can use the configuration tool or we can use the command line, of course we will use the command line
If you ever try to debug a script task by setting a breakpoint and the package is on a 64 bit machine it will just ignpore the breakpoint.
I ran into this problem myself a while ago and this week a co-worker also ran into it and asked me how to resolve it.
It is pretty simple, all you have to do is click on Project, then select Debug Properties. Under Configuration Properties, click on Debugging. Make Run64BitRuntime False. See image below.
This will not work on SQL Server 2000 since the sp_refreshsqlmodule does not exists on that version!
A while back in the What is deferred name resolution and why do you need to care? blogpost I showed you that sp_depens is not reliable because you can create procedures that reference objects that have not been created yet.
You can use sp_refreshsqlmodule to help 'fix' that
let's take a look at how that works
First create this awesome stored procedur...
If you want to show a 1 when there is a value for something in the column and 0 if none of the rows have that values you typically do something like this
If you have a bunch of User-Defined Data Types in your databases and you would like to get a list of them then you can run the following query
On SQL Server 2000 and up
So I posted a teaser in the puzzles forum. Without running this, try to guess what will happen?
:: Next >>