Viewing 15 posts - 2,356 through 2,370 (of 5,841 total)
madhu-686862 (10/8/2013)
Questions:
1. Can one cluster node should be enoguh to configure AlwaysOn Availability Groups?
2. The node hosting the secondary replica, must be part...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 8, 2013 at 9:12 pm
I hadn't heard that reverse engineering sql objects was deprecated in Visio 2013!! That kinda sucks for a lot of people I think.
Anyway, I HIGHLY recommend Embarcadero's ERStudio product. ...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 1, 2013 at 5:54 pm
You either shrink or you export all data, build a new database, and import all data.
I am afraid that getting deeper into why you cannot shrink the database file (it...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 1, 2013 at 10:17 am
It could well be the tlog that is taking up all the space you see in that particular output. try dbcc sqlperf(logspace) and see if you have a huge...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 1, 2013 at 7:37 am
Stefan_G (9/27/2013)
The problem went away when we installed CU4.http://support.microsoft.com/kb/2845380
See this thread for more info:
http://www.sqlservercentral.com/Forums/Topic1415833-2799-1.aspx
Good luck!
Glad you got it fixed! Well, glad MICROSOFT fixed it!! 🙂
I am coming across...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 27, 2013 at 3:42 am
Thomas Mucha (9/26/2013)
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 26, 2013 at 3:47 pm
GilaMonster (9/26/2013)
TheSQLGuru (9/26/2013)
There are many things that happen in temp tables that are not logged
Temp tables are logged. There are NO unlogged operations in SQL other than inserts into the...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 26, 2013 at 3:40 pm
Knut Boehnert (9/25/2013)
If the structure is stable and the same at every import I prefer to use a permanent temp table. That is define the permanent table with a...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 26, 2013 at 4:17 am
1) sp_whoisactive (sqlblog.com I think version 11.11 is latest)
2) track_waitstats_2005 (found in the sql server 2005 waits and queues white paper IIRC) to do a wait stats analysis
3) run a...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 24, 2013 at 9:43 am
DDL triggers. However, these can be disabled by users with sufficient permissions so they are not fool-proof.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 24, 2013 at 9:32 am
vignesh.ms (9/24/2013)
Hi There ,Im handling cores of data which will refreshed in every run.
for this which one I can go with ? temp table or permanent table ?
I always default...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 24, 2013 at 9:31 am
We need to see the query plan to help.
But you might try inserting the SELECT stuff you need for the update into a temp table (NOT table variable) and running...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 24, 2013 at 9:29 am
A text editor is the minimum you need to create a new schema (CREATE TABLE abc ...). 🙂
SSMS has a totally crappy ability to do this graphically (see the Database...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 23, 2013 at 10:08 am
GilaMonster (9/20/2013)
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
+1
How can we optimize a query without knowing the tables, indexes, views, functions, etc in play?
Data distribution will...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 20, 2013 at 9:41 am
I too will recommend Kimball.
I will also add that I have been pulled into numerous DW projects as a consultant that were near or complete failures, in an effort to...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 20, 2013 at 9:38 am
Viewing 15 posts - 2,356 through 2,370 (of 5,841 total)