Viewing 15 posts - 466 through 480 (of 687 total)
Syed Jahanzaib Bin hassan (6/30/2011)
DBCC SHRINKDATABASEVisit this link
don't listen to him ^
What Mr. Fritchey suggests is best if your problem is that you are running out of disk space...
June 30, 2011 at 6:55 am
insert into [good_table]
(col1, col2, col3)
select
colA,
colB,
cast(left([ColC], 2) + '/' + SUBSTRING([ColC], 2, 2) + '/' + RIGHT([ColC], 4) as datetime)
FROM [dumb_table]
Something like that
June 29, 2011 at 10:59 am
SELECT name,recovery_model_desc
FROM sys.databases
That will tell you the recovery model for each database.
June 29, 2011 at 10:31 am
Grant Fritchey (6/29/2011)
calvo (6/29/2011)
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.
^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that...
June 29, 2011 at 6:32 am
If you post the actual query plan please, experts will be able to help in a more expeditious manner.
June 29, 2011 at 6:21 am
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.
^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now, assuming...
June 29, 2011 at 6:19 am
with CTE as
(
select name,nameid
from #names
)
SELECT
name,
offidlist = STUFF((
SELECT
...
June 28, 2011 at 9:23 am
Rank1_nj (6/28/2011)
IF @RandomCol = 'YES'
or am I relacing the @RandomCol Varaible's SET select statement?
because I tried replacing it with...
June 28, 2011 at 9:16 am
Duran (6/28/2011)
I have having to reinstall a copy of SQL server 2008 after it was destroyed when the a drive was deleted.
d'oh!
How long have you waited after the screen...
June 28, 2011 at 8:36 am
Since the @randomCol declared variable is never used and you're only performing an action if a user's field = 'yes',
instead of:
declare @randomCol varchar(100)
set @randomCol =
(Select RandomCol
from TableA
where...
June 28, 2011 at 8:31 am
DDL scripts, sample data, and expected output would be helpful.
June 28, 2011 at 8:09 am
Daniel Bowlin (6/24/2011)
June 24, 2011 at 10:24 am
I think the most important question to answer when trying to decide HA options is, what is the business requirement?
Is there an acceptable amount of downtime? Does the secondary server...
June 24, 2011 at 10:16 am
Oh man!
Riggleman (Nationals) just up and quits after a 1-0 win against the Mariners.
He said he did it on principal, but even if he's right about Rizzo not wanting to...
June 24, 2011 at 7:09 am
Viewing 15 posts - 466 through 480 (of 687 total)