Viewing 15 posts - 2,056 through 2,070 (of 3,669 total)
For SQL2008 there is a web edition that is licensed to 4 CPUs. It sits somewhere between SQL Express and Standard Edition but with considerably cheaper licensing.
Having just gone...
June 8, 2009 at 3:18 pm
I.m using SQL2008 so the exact option may differ to mine.
In SQL Management Studio from the tools/options menu look for the "query results" branch on the left hand side.
In results...
June 7, 2009 at 10:24 am
One of Scott Adam's Dilbert cartoons is about an employees "numbing". This is when the employee realises that he/she is not appreciated, he/she is simply expected to be a...
May 19, 2009 at 9:36 am
I haven't got a degree.
I fell into becoming a DBA through an interest in statistics in relation to predicting future customer behaviour from past behaviour.
May 5, 2009 at 1:34 am
Personally I would set up an explicit Domain SQLAdmin group with very tightly controlled membership.
Make this group a sysadmin and get rid of NTAuthority/System.
You need to make sure that the...
April 26, 2009 at 1:50 pm
How many people have you got trying to connect to your instance?
What edition of SQL Server are you running?
What is the licensing model for your SQL Server. Is it per...
April 24, 2009 at 12:13 pm
17187 means that SQL Server cannot accept anymore client connections. There was a fix in SP2 as SQL Server was sometimes overzealous in issuing this command.
18456 is a "login...
April 23, 2009 at 1:51 pm
Because of my auditing needs I have a structure that is something like the following
UserID
VersionNumber
UserName
... additional fields to identify who did what and when.
The primary key is across the first...
April 23, 2009 at 6:49 am
Even bog standard Visio Professional will reverse engineer. It is the enterprise architect edition that forward engineers.
You could look at Sparx Data Architect as a possible tool or Erwin.
April 23, 2009 at 6:43 am
In data warehousing solutions the recommendation (Ralph Kimball) is to have a single field surrogate key.
In OLTP solutions I think it depends on how static the data is.
In my case...
April 23, 2009 at 6:40 am
As a matter of interest why do you allow the tblUsers table to have NULL values.
Why not put a DEFAULT constraint with an empty string on them. It would...
April 3, 2009 at 11:44 am
The last books I bought were Klaus Aschenbrenner's Pro SQL Server 2005 Service Broker and the MCTIP training courses for SQL2008.
The problem is that books are relatively expensive door stops...
March 30, 2009 at 12:28 pm
kuldip.bhatt (3/24/2009)
how i give the usrename and password in the sql command?:setvar Maindbserver "NHSserver"
:setvar Maindb "NHS_031209"
:Connect $(Maindbserver)
go
$ maindb
:connect $(Maindbserver) -U YourUserName -P YourPassword
Personally I would avoid SQL standard...
March 24, 2009 at 7:28 am
Back in the early 1990s I got made redundant on my birthday. Of course they waited until after lunch when I had bought the cakes that employees are supposed...
March 16, 2009 at 12:30 pm
In addition to the above I would look at putting the tables on separate file groups and possibly separating out the indexes from the data.
March 2, 2009 at 10:54 am
Viewing 15 posts - 2,056 through 2,070 (of 3,669 total)