Viewing 15 posts - 16,246 through 16,260 (of 49,552 total)
DBA_Learner (10/8/2012)
If server_A fails, then On Server_B we will execute the following command...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 8:02 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1369730-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 6:11 am
With what error? Just saying it's failing isn't much use.
Maintenance:
Backups, full maybe diff, probably log depending on RPO and RTO requirements
Index maintenance
Integrity checks
Possible additional statistics maintenance
Test restores to ensure your...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 5:17 am
SQLSACT (10/8/2012)
Usergroup meetings?
Yes, the monthly meetings of the SQL Server usergroups
I was wondering if there will be any SQLSaturdays\PASS Events happening on our side of the world anytime soon.
There were...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 2:02 am
As a once-off operation, shrink's OK. See the article I referenced.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 1:58 am
Firstly, that's entirely normal.
If you want to reduce SQL's memory usage, set max server memory to a sensible value. If you leave it at default, you're telling SQL that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 1:49 am
SQLSACT (10/8/2012)
GilaMonster (10/7/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 1:45 am
elham_azizi_62 (10/7/2012)
I want to have this:select column1 from table1
column1
a
b
c
and result:a,b,c
and i donot want to use cursor or virtual table.please help me.thanks
GilaMonster (10/7/2012)
Take a look at the last option here: http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2012 at 1:45 am
dflbob (10/7/2012)
ok, I think I've got it. Go for MCSA (Associate) as it covers both the previous MCTS and MCITP.
No it doesn't. The 2009 one's a combination of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 2:33 pm
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-all.aspx#tab2
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2008 certification validates a set of core SQL Server 2008 skills that are relevant across multiple job roles.
The MCSA: SQL Server 2008...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 2:06 pm
dflbob (10/7/2012)
I reviewed the link, where is it stated that SSIS, SSRS and SSAS are part of SQL 2012?
Click on MCSA and MCSE:Business Intelligence and check each of the exams...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 12:55 pm
They're part of the BI certs. See the link I posted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 12:31 pm
No, it doesn't know the value, nor can it with the code you posted.
The optimiser does not and can not execute queries (that's what the query execution engine does). So...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 11:45 am
Take a look at the last option here: http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 6:08 am
Firstly you're missing a GO after the procedure's declaration
The assignment in the procedure's execution is the wrong way around. It's Parameter = Variable/Constant, not Variable = Parameter.
create procedure outname
@Cont Int,
@Nm...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2012 at 3:35 am
Viewing 15 posts - 16,246 through 16,260 (of 49,552 total)