Viewing 15 posts - 16 through 30 (of 38 total)
I think this way is better:
SET XACT_ABORT ON
BEGIN TRY
BEGIN TRAN
CREATE CLUSTERED INDEX ix_TableA_Transfer ON tableA (id) ON [PRIMARY]
COMMIT
END TRY
BEGIN CATCH
ROLLBACK
END CATCH
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 11, 2009 at 1:38 pm
Here is what I use. I create or rebuild de cluster index or primary key within a transaction to protect the integrity of the table in case of failure:
SET XACT_ABORT...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 11, 2009 at 1:36 pm
Wow, I just hit the ground hard!!
Excelent!!
Alberto
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 10, 2009 at 2:18 pm
Gail, what happens when, after monitoring your data growth for years, you discover that it only fills a little percentage of the datafile, and you are getting short of disk...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 8, 2009 at 4:15 pm
nchar(1) is the one. I agree with all explanations above.
Alberto
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 5, 2009 at 11:39 am
Hi:
Server roles in SQL Server are fixed, you can't create, modify or delete a server role.
Check theese:
http://msdn.microsoft.com/en-us/library/ms175892.aspx
http://www.sqlservercentral.com/articles/Administration/sqlserversecurityfixedroles/1163/
In the Other hand, you can create new Dataase Roles:
http://msdn.microsoft.com/en-us/library/ms189121.aspx
Alberto
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 2, 2009 at 11:40 am
Hi:
This is a common practice in datawharehousing. That smaller key is named subrogated key. You can save space, yes. But I think that's not the main purpose of it. Normally,...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 1, 2009 at 3:24 pm
or here:
http://msdn.microsoft.com/en-us/library/ms191524(SQL.90).aspx
Alberto
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 1, 2009 at 3:07 pm
Start here:
http://msdn.microsoft.com/en-us/library/ms178110(SQL.90).aspx
Good luck.
Alberto
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 1, 2009 at 3:06 pm
It looks like the problem is about security. You allready had some advice about firewall settings. Take a look to the Security Settings in the linked server properties:
You can use...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
June 1, 2009 at 11:20 am
Hi, If the table is in a different instance or server, you first need to configure a linked server, and write the following statement:
Insert into dbo.LocalTable (LField1, LField2, LField3)
Select (RField4,...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
May 28, 2009 at 11:47 am
If you have Office 2007 Pro there's a new tool called Infopath to make forms.
Good Luck
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
May 28, 2009 at 11:28 am
Try using Linked Server instead of Openrowset, it's kind of slow but it worked for me
NOTE:
--I've tried this with Excel 2003, not 2007
--Its kind of...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
May 28, 2009 at 10:51 am
ALELUYA!!
thanks a lot
Alberto
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
May 26, 2009 at 2:31 pm
Hi Steve:
I can get into forums with specific URL, but when I call http://www.sqlservercentral.com I'm still getting this message:
ZoneEdit DNS services for this domain have expired.
To reactivate service for SQLSERVERCENTRAL.COM,...
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader
May 26, 2009 at 2:24 pm
Viewing 15 posts - 16 through 30 (of 38 total)