Viewing 15 posts - 541 through 555 (of 3,221 total)
Here is a code sample, that you might want to include in a job set to run on a daily basis. Insert the results into a table for review...
April 2, 2012 at 7:45 am
Another thought for the long haul ..
Database Mirroring (SQL Server)
SQL Server 2012
http://msdn.microsoft.com/en-us/library/ms189852.aspx
which states:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this...
April 2, 2012 at 5:32 am
Denise McMillan (3/30/2012)
I was hoping to do this without a second table though. I'm not using all the fields in the table to get the...
March 30, 2012 at 7:28 am
A quick and simple answer is No you can not
CREATE TABLE #A(Age INT,Id INT IDENTITY(1,1))
DECLARE @X INT
SET @X = 20
WHILE @X < 30
BEGIN
...
March 29, 2012 at 5:53 pm
Like so much of SQL the answer is it depends. In this case is the number of rows which will remain, a in significant number or percentage of the...
March 29, 2012 at 5:15 pm
Look at using ISNULL
http://msdn.microsoft.com/en-us/library/ms184325(v=sql.100).aspx
March 28, 2012 at 4:26 pm
sqlnaive (3/28/2012)
Is there a way I can find out the row size fo a table ?
1. Is the table a heap (no indexes) or does it contain indexes?
2. ...
March 28, 2012 at 9:32 am
Koen Verbeeck (3/28/2012)
GSquared (3/28/2012)
Koen Verbeeck (3/28/2012)
David Burrows (3/28/2012)
SQLRNNR (3/27/2012)
When did we start doing milestones for the 5k posts? I thought it was 10k.
A milestone is a milestone is a...
March 28, 2012 at 8:42 am
What is the compatability level of you Model DB ?
March 27, 2012 at 6:21 pm
davidandrews13 (3/27/2012)
Carlo Romagnano (3/27/2012)
Easy question!Good practice is never use "SELECT * FROM" in view, too.
😉
surely it doesn't matter if you do SELECT *?
every time i create or update a view...
March 27, 2012 at 8:55 am
To start the discussion - Tech Specs Shall we discuss the change or rate of change (now increasing) of the Worlds population. Whose estimates (United Nations forecast, or...
March 27, 2012 at 8:47 am
Brandie Tarvin (3/26/2012)
How would you all like to design the system (and database) around this one: http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7
Look I am old with grey hair but so far no ulcer's no uncontrolable...
March 26, 2012 at 5:06 pm
Look at using the REVERSE function, something like this:
DECLARE @T VARCHAR(50)
SET @T = 'building,test ,test,Åland ,'
SELECT REVERSE(SUBSTRING(REVERSE(@T),2,LEN(@T)))
Result:
building,test ,test,Åland
March 26, 2012 at 2:38 pm
Viewing 15 posts - 541 through 555 (of 3,221 total)